Dataset statistics
| Number of variables | 151 |
|---|---|
| Number of observations | 42536 |
| Missing cells | 3840156 |
| Missing cells (%) | 59.8% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 49.0 MiB |
| Average record size in memory | 1.2 KiB |
Variable types
| Unsupported | 83 |
|---|---|
| Numeric | 29 |
| Categorical | 35 |
| Boolean | 4 |
pymnt_plan has constant value "False" | Constant |
initial_list_status has constant value "False" | Constant |
out_prncp has constant value "0.0" | Constant |
out_prncp_inv has constant value "0.0" | Constant |
collections_12_mths_ex_med has constant value "0.0" | Constant |
policy_code has constant value "1.0" | Constant |
application_type has constant value "Individual" | Constant |
chargeoff_within_12_mths has constant value "0.0" | Constant |
hardship_flag has constant value "False" | Constant |
disbursement_method has constant value "Cash" | Constant |
int_rate has a high cardinality: 394 distinct values | High cardinality |
emp_title has a high cardinality: 30658 distinct values | High cardinality |
issue_d has a high cardinality: 55 distinct values | High cardinality |
url has a high cardinality: 42535 distinct values | High cardinality |
desc has a high cardinality: 28963 distinct values | High cardinality |
title has a high cardinality: 21264 distinct values | High cardinality |
zip_code has a high cardinality: 837 distinct values | High cardinality |
earliest_cr_line has a high cardinality: 530 distinct values | High cardinality |
revol_util has a high cardinality: 1119 distinct values | High cardinality |
last_pymnt_d has a high cardinality: 112 distinct values | High cardinality |
next_pymnt_d has a high cardinality: 98 distinct values | High cardinality |
last_credit_pull_d has a high cardinality: 133 distinct values | High cardinality |
debt_settlement_flag_date has a high cardinality: 63 distinct values | High cardinality |
settlement_date has a high cardinality: 61 distinct values | High cardinality |
loan_amnt is highly correlated with funded_amnt and 2 other fields | High correlation |
funded_amnt is highly correlated with loan_amnt and 2 other fields | High correlation |
funded_amnt_inv is highly correlated with loan_amnt and 2 other fields | High correlation |
installment is highly correlated with loan_amnt and 1 other fields | High correlation |
fico_range_low is highly correlated with fico_range_high | High correlation |
fico_range_high is highly correlated with fico_range_low | High correlation |
total_pymnt is highly correlated with total_pymnt_inv and 1 other fields | High correlation |
total_pymnt_inv is highly correlated with funded_amnt_inv and 2 other fields | High correlation |
total_rec_prncp is highly correlated with total_pymnt and 1 other fields | High correlation |
term is highly correlated with policy_code and 9 other fields | High correlation |
policy_code is highly correlated with term and 27 other fields | High correlation |
disbursement_method is highly correlated with term and 27 other fields | High correlation |
delinq_amnt is highly correlated with policy_code and 13 other fields | High correlation |
application_type is highly correlated with term and 27 other fields | High correlation |
grade is highly correlated with policy_code and 10 other fields | High correlation |
out_prncp is highly correlated with term and 27 other fields | High correlation |
loan_status is highly correlated with policy_code and 9 other fields | High correlation |
chargeoff_within_12_mths is highly correlated with term and 27 other fields | High correlation |
sub_grade is highly correlated with policy_code and 10 other fields | High correlation |
purpose is highly correlated with policy_code and 9 other fields | High correlation |
acc_now_delinq is highly correlated with policy_code and 13 other fields | High correlation |
settlement_date is highly correlated with policy_code and 14 other fields | High correlation |
next_pymnt_d is highly correlated with policy_code and 10 other fields | High correlation |
collections_12_mths_ex_med is highly correlated with term and 27 other fields | High correlation |
verification_status is highly correlated with policy_code and 9 other fields | High correlation |
pub_rec_bankruptcies is highly correlated with policy_code and 12 other fields | High correlation |
issue_d is highly correlated with policy_code and 9 other fields | High correlation |
addr_state is highly correlated with policy_code and 9 other fields | High correlation |
debt_settlement_flag_date is highly correlated with policy_code and 13 other fields | High correlation |
hardship_flag is highly correlated with term and 27 other fields | High correlation |
pymnt_plan is highly correlated with term and 27 other fields | High correlation |
settlement_status is highly correlated with policy_code and 13 other fields | High correlation |
out_prncp_inv is highly correlated with term and 27 other fields | High correlation |
home_ownership is highly correlated with policy_code and 9 other fields | High correlation |
initial_list_status is highly correlated with term and 27 other fields | High correlation |
tax_liens is highly correlated with policy_code and 13 other fields | High correlation |
emp_length is highly correlated with policy_code and 9 other fields | High correlation |
debt_settlement_flag is highly correlated with policy_code and 12 other fields | High correlation |
member_id has 42536 (100.0%) missing values | Missing |
emp_title has 2627 (6.2%) missing values | Missing |
emp_length has 1113 (2.6%) missing values | Missing |
desc has 13294 (31.3%) missing values | Missing |
mths_since_last_record has 38885 (91.4%) missing values | Missing |
next_pymnt_d has 39787 (93.5%) missing values | Missing |
mths_since_last_major_derog has 42536 (100.0%) missing values | Missing |
annual_inc_joint has 42536 (100.0%) missing values | Missing |
dti_joint has 42536 (100.0%) missing values | Missing |
verification_status_joint has 42536 (100.0%) missing values | Missing |
tot_coll_amt has 42536 (100.0%) missing values | Missing |
tot_cur_bal has 42536 (100.0%) missing values | Missing |
open_acc_6m has 42536 (100.0%) missing values | Missing |
open_act_il has 42536 (100.0%) missing values | Missing |
open_il_12m has 42536 (100.0%) missing values | Missing |
open_il_24m has 42536 (100.0%) missing values | Missing |
mths_since_rcnt_il has 42536 (100.0%) missing values | Missing |
total_bal_il has 42536 (100.0%) missing values | Missing |
il_util has 42536 (100.0%) missing values | Missing |
open_rv_12m has 42536 (100.0%) missing values | Missing |
open_rv_24m has 42536 (100.0%) missing values | Missing |
max_bal_bc has 42536 (100.0%) missing values | Missing |
all_util has 42536 (100.0%) missing values | Missing |
total_rev_hi_lim has 42536 (100.0%) missing values | Missing |
inq_fi has 42536 (100.0%) missing values | Missing |
total_cu_tl has 42536 (100.0%) missing values | Missing |
inq_last_12m has 42536 (100.0%) missing values | Missing |
acc_open_past_24mths has 42536 (100.0%) missing values | Missing |
avg_cur_bal has 42536 (100.0%) missing values | Missing |
bc_open_to_buy has 42536 (100.0%) missing values | Missing |
bc_util has 42536 (100.0%) missing values | Missing |
mo_sin_old_il_acct has 42536 (100.0%) missing values | Missing |
mo_sin_old_rev_tl_op has 42536 (100.0%) missing values | Missing |
mo_sin_rcnt_rev_tl_op has 42536 (100.0%) missing values | Missing |
mo_sin_rcnt_tl has 42536 (100.0%) missing values | Missing |
mort_acc has 42536 (100.0%) missing values | Missing |
mths_since_recent_bc has 42536 (100.0%) missing values | Missing |
mths_since_recent_bc_dlq has 42536 (100.0%) missing values | Missing |
mths_since_recent_inq has 42536 (100.0%) missing values | Missing |
mths_since_recent_revol_delinq has 42536 (100.0%) missing values | Missing |
num_accts_ever_120_pd has 42536 (100.0%) missing values | Missing |
num_actv_bc_tl has 42536 (100.0%) missing values | Missing |
num_actv_rev_tl has 42536 (100.0%) missing values | Missing |
num_bc_sats has 42536 (100.0%) missing values | Missing |
num_bc_tl has 42536 (100.0%) missing values | Missing |
num_il_tl has 42536 (100.0%) missing values | Missing |
num_op_rev_tl has 42536 (100.0%) missing values | Missing |
num_rev_accts has 42536 (100.0%) missing values | Missing |
num_rev_tl_bal_gt_0 has 42536 (100.0%) missing values | Missing |
num_sats has 42536 (100.0%) missing values | Missing |
num_tl_120dpd_2m has 42536 (100.0%) missing values | Missing |
num_tl_30dpd has 42536 (100.0%) missing values | Missing |
num_tl_90g_dpd_24m has 42536 (100.0%) missing values | Missing |
num_tl_op_past_12m has 42536 (100.0%) missing values | Missing |
pct_tl_nvr_dlq has 42536 (100.0%) missing values | Missing |
percent_bc_gt_75 has 42536 (100.0%) missing values | Missing |
pub_rec_bankruptcies has 1366 (3.2%) missing values | Missing |
tot_hi_cred_lim has 42536 (100.0%) missing values | Missing |
total_bal_ex_mort has 42536 (100.0%) missing values | Missing |
total_bc_limit has 42536 (100.0%) missing values | Missing |
total_il_high_credit_limit has 42536 (100.0%) missing values | Missing |
revol_bal_joint has 42536 (100.0%) missing values | Missing |
sec_app_fico_range_low has 42536 (100.0%) missing values | Missing |
sec_app_fico_range_high has 42536 (100.0%) missing values | Missing |
sec_app_earliest_cr_line has 42536 (100.0%) missing values | Missing |
sec_app_inq_last_6mths has 42536 (100.0%) missing values | Missing |
sec_app_mort_acc has 42536 (100.0%) missing values | Missing |
sec_app_open_acc has 42536 (100.0%) missing values | Missing |
sec_app_revol_util has 42536 (100.0%) missing values | Missing |
sec_app_open_act_il has 42536 (100.0%) missing values | Missing |
sec_app_num_rev_accts has 42536 (100.0%) missing values | Missing |
sec_app_chargeoff_within_12_mths has 42536 (100.0%) missing values | Missing |
sec_app_collections_12_mths_ex_med has 42536 (100.0%) missing values | Missing |
sec_app_mths_since_last_major_derog has 42536 (100.0%) missing values | Missing |
hardship_type has 42536 (100.0%) missing values | Missing |
hardship_reason has 42536 (100.0%) missing values | Missing |
hardship_status has 42536 (100.0%) missing values | Missing |
deferral_term has 42536 (100.0%) missing values | Missing |
hardship_amount has 42536 (100.0%) missing values | Missing |
hardship_start_date has 42536 (100.0%) missing values | Missing |
hardship_end_date has 42536 (100.0%) missing values | Missing |
payment_plan_start_date has 42536 (100.0%) missing values | Missing |
hardship_length has 42536 (100.0%) missing values | Missing |
hardship_dpd has 42536 (100.0%) missing values | Missing |
hardship_loan_status has 42536 (100.0%) missing values | Missing |
orig_projected_additional_accrued_interest has 42536 (100.0%) missing values | Missing |
hardship_payoff_balance_amount has 42536 (100.0%) missing values | Missing |
hardship_last_payment_amount has 42536 (100.0%) missing values | Missing |
debt_settlement_flag_date has 42376 (99.6%) missing values | Missing |
settlement_status has 42376 (99.6%) missing values | Missing |
settlement_date has 42376 (99.6%) missing values | Missing |
settlement_amount has 42376 (99.6%) missing values | Missing |
settlement_percentage has 42376 (99.6%) missing values | Missing |
settlement_term has 42376 (99.6%) missing values | Missing |
annual_inc is highly skewed (γ1 = 29.03489277) | Skewed |
collection_recovery_fee is highly skewed (γ1 = 22.41007601) | Skewed |
url is uniformly distributed | Uniform |
id is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
member_id is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
mths_since_last_major_derog is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
annual_inc_joint is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
dti_joint is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
verification_status_joint is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
tot_coll_amt is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
tot_cur_bal is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
open_acc_6m is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
open_act_il is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
open_il_12m is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
open_il_24m is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
mths_since_rcnt_il is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
total_bal_il is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
il_util is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
open_rv_12m is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
open_rv_24m is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
max_bal_bc is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
all_util is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
total_rev_hi_lim is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
inq_fi is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
total_cu_tl is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
inq_last_12m is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
acc_open_past_24mths is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
avg_cur_bal is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
bc_open_to_buy is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
bc_util is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
mo_sin_old_il_acct is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
mo_sin_old_rev_tl_op is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
mo_sin_rcnt_rev_tl_op is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
mo_sin_rcnt_tl is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
mort_acc is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
mths_since_recent_bc is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
mths_since_recent_bc_dlq is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
mths_since_recent_inq is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
mths_since_recent_revol_delinq is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
num_accts_ever_120_pd is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
num_actv_bc_tl is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
num_actv_rev_tl is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
num_bc_sats is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
num_bc_tl is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
num_il_tl is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
num_op_rev_tl is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
num_rev_accts is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
num_rev_tl_bal_gt_0 is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
num_sats is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
num_tl_120dpd_2m is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
num_tl_30dpd is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
num_tl_90g_dpd_24m is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
num_tl_op_past_12m is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
pct_tl_nvr_dlq is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
percent_bc_gt_75 is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
tot_hi_cred_lim is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
total_bal_ex_mort is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
total_bc_limit is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
total_il_high_credit_limit is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
revol_bal_joint is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
sec_app_fico_range_low is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
sec_app_fico_range_high is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
sec_app_earliest_cr_line is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
sec_app_inq_last_6mths is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
sec_app_mort_acc is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
sec_app_open_acc is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
sec_app_revol_util is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
sec_app_open_act_il is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
sec_app_num_rev_accts is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
sec_app_chargeoff_within_12_mths is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
sec_app_collections_12_mths_ex_med is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
sec_app_mths_since_last_major_derog is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
hardship_type is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
hardship_reason is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
hardship_status is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
deferral_term is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
hardship_amount is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
hardship_start_date is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
hardship_end_date is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
payment_plan_start_date is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
hardship_length is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
hardship_dpd is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
hardship_loan_status is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
orig_projected_additional_accrued_interest is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
hardship_payoff_balance_amount is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
hardship_last_payment_amount is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
delinq_2yrs has 37771 (88.8%) zeros | Zeros |
inq_last_6mths has 19657 (46.2%) zeros | Zeros |
mths_since_last_delinq has 27748 (65.2%) zeros | Zeros |
mths_since_last_record has 1275 (3.0%) zeros | Zeros |
pub_rec has 40130 (94.3%) zeros | Zeros |
revol_bal has 1119 (2.6%) zeros | Zeros |
total_rec_late_fee has 40145 (94.4%) zeros | Zeros |
recoveries has 36176 (85.0%) zeros | Zeros |
collection_recovery_fee has 38207 (89.8%) zeros | Zeros |
last_fico_range_low has 795 (1.9%) zeros | Zeros |
Reproduction
| Analysis started | 2021-03-24 08:34:11.327887 |
|---|---|
| Analysis finished | 2021-03-24 08:35:56.943725 |
| Duration | 1 minute and 45.62 seconds |
| Software version | pandas-profiling v2.11.0 |
| Download configuration | config.yaml |
| Distinct | 898 |
|---|---|
| Distinct (%) | 2.1% |
| Missing | 1 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 11089.72258 |
|---|---|
| Minimum | 500 |
| Maximum | 35000 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 332.4 KiB |
Quantile statistics
| Minimum | 500 |
|---|---|
| 5-th percentile | 2400 |
| Q1 | 5200 |
| median | 9700 |
| Q3 | 15000 |
| 95-th percentile | 25000 |
| Maximum | 35000 |
| Range | 34500 |
| Interquartile range (IQR) | 9800 |
Descriptive statistics
| Standard deviation | 7410.938391 |
|---|---|
| Coefficient of variation (CV) | 0.6682708549 |
| Kurtosis | 0.7858727169 |
| Mean | 11089.72258 |
| Median Absolute Deviation (MAD) | 4700 |
| Skewness | 1.064970449 |
| Sum | 471701350 |
| Variance | 54922007.83 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) |
| 10000 | 3016 | 7.1% |
| 12000 | 2439 | 5.7% |
| 5000 | 2260 | 5.3% |
| 6000 | 2037 | 4.8% |
| 15000 | 2012 | 4.7% |
| 20000 | 1724 | 4.1% |
| 8000 | 1699 | 4.0% |
| 25000 | 1499 | 3.5% |
| 4000 | 1230 | 2.9% |
| 3000 | 1134 | 2.7% |
| Other values (888) | 23485 |
| Value | Count | Frequency (%) |
| 500 | 11 | |
| 550 | 1 | < 0.1% |
| 600 | 6 | |
| 700 | 3 | < 0.1% |
| 725 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 35000 | 685 | |
| 34800 | 2 | < 0.1% |
| 34675 | 1 | < 0.1% |
| 34525 | 1 | < 0.1% |
| 34475 | 5 | < 0.1% |
| Distinct | 1051 |
|---|---|
| Distinct (%) | 2.5% |
| Missing | 1 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 10821.58575 |
|---|---|
| Minimum | 500 |
| Maximum | 35000 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 332.4 KiB |
Quantile statistics
| Minimum | 500 |
|---|---|
| 5-th percentile | 2275 |
| Q1 | 5000 |
| median | 9600 |
| Q3 | 15000 |
| 95-th percentile | 25000 |
| Maximum | 35000 |
| Range | 34500 |
| Interquartile range (IQR) | 10000 |
Descriptive statistics
| Standard deviation | 7146.914675 |
|---|---|
| Coefficient of variation (CV) | 0.6604313673 |
| Kurtosis | 0.9480112486 |
| Mean | 10821.58575 |
| Median Absolute Deviation (MAD) | 4600 |
| Skewness | 1.085767061 |
| Sum | 460296150 |
| Variance | 51078389.37 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) |
| 10000 | 2924 | 6.9% |
| 12000 | 2347 | 5.5% |
| 5000 | 2247 | 5.3% |
| 6000 | 2023 | 4.8% |
| 15000 | 1897 | 4.5% |
| 8000 | 1686 | 4.0% |
| 20000 | 1546 | 3.6% |
| 4000 | 1230 | 2.9% |
| 25000 | 1224 | 2.9% |
| 3000 | 1125 | 2.6% |
| Other values (1041) | 24286 |
| Value | Count | Frequency (%) |
| 500 | 11 | |
| 550 | 1 | < 0.1% |
| 600 | 6 | |
| 700 | 3 | < 0.1% |
| 725 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 35000 | 559 | |
| 34800 | 1 | < 0.1% |
| 34675 | 2 | < 0.1% |
| 34525 | 1 | < 0.1% |
| 34475 | 4 | < 0.1% |
| Distinct | 9248 |
|---|---|
| Distinct (%) | 21.7% |
| Missing | 1 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 10139.93878 |
|---|---|
| Minimum | 0 |
| Maximum | 35000 |
| Zeros | 233 |
| Zeros (%) | 0.5% |
| Memory size | 332.4 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1500 |
| Q1 | 4950 |
| median | 8500 |
| Q3 | 14000 |
| 95-th percentile | 24575 |
| Maximum | 35000 |
| Range | 35000 |
| Interquartile range (IQR) | 9050 |
Descriptive statistics
| Standard deviation | 7131.598014 |
|---|---|
| Coefficient of variation (CV) | 0.7033176595 |
| Kurtosis | 1.070262642 |
| Mean | 10139.93878 |
| Median Absolute Deviation (MAD) | 4223.770511 |
| Skewness | 1.104831459 |
| Sum | 431302296.2 |
| Variance | 50859690.23 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) |
| 5000 | 1369 | 3.2% |
| 10000 | 1302 | 3.1% |
| 6000 | 1240 | 2.9% |
| 12000 | 1084 | 2.5% |
| 8000 | 929 | 2.2% |
| 3000 | 851 | 2.0% |
| 4000 | 850 | 2.0% |
| 15000 | 664 | 1.6% |
| 7000 | 615 | 1.4% |
| 2000 | 486 | 1.1% |
| Other values (9238) | 33145 |
| Value | Count | Frequency (%) |
| 0 | 233 | |
| 0.000121098108 | 1 | < 0.1% |
| 0.000185369401 | 1 | < 0.1% |
| 0.000242055511 | 1 | < 0.1% |
| 0.000531133069 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 35000 | 135 | |
| 34997.35245 | 1 | < 0.1% |
| 34993.65539 | 1 | < 0.1% |
| 34993.32571 | 1 | < 0.1% |
| 34993.26306 | 1 | < 0.1% |
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 1 |
| Missing (%) | < 0.1% |
| Memory size | 332.4 KiB |
| 36 months | |
|---|---|
| 60 months |
Length
| Max length | 10 |
|---|---|
| Median length | 10 |
| Mean length | 10 |
| Min length | 10 |
Characters and Unicode
| Total characters | 425350 |
|---|---|
| Distinct characters | 10 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 36 months |
|---|---|
| 2nd row | 60 months |
| 3rd row | 36 months |
| 4th row | 36 months |
| 5th row | 60 months |
| Value | Count | Frequency (%) |
| 36 months | 31534 | |
| 60 months | 11001 | 25.9% |
| (Missing) | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| months | 42535 | |
| 36 | 31534 | |
| 60 | 11001 | 12.9% |
Most occurring characters
| Value | Count | Frequency (%) |
| 85070 | ||
| 6 | 42535 | |
| m | 42535 | |
| o | 42535 | |
| n | 42535 | |
| t | 42535 | |
| h | 42535 | |
| s | 42535 | |
| 3 | 31534 | 7.4% |
| 0 | 11001 | 2.6% |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 255210 | |
| Space Separator | 85070 | 20.0% |
| Decimal Number | 85070 | 20.0% |
Most frequent character per category
| Value | Count | Frequency (%) |
| m | 42535 | |
| o | 42535 | |
| n | 42535 | |
| t | 42535 | |
| h | 42535 | |
| s | 42535 |
| Value | Count | Frequency (%) |
| 6 | 42535 | |
| 3 | 31534 | |
| 0 | 11001 | 12.9% |
| Value | Count | Frequency (%) |
| 85070 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 255210 | |
| Common | 170140 |
Most frequent character per script
| Value | Count | Frequency (%) |
| m | 42535 | |
| o | 42535 | |
| n | 42535 | |
| t | 42535 | |
| h | 42535 | |
| s | 42535 |
| Value | Count | Frequency (%) |
| 85070 | ||
| 6 | 42535 | |
| 3 | 31534 | 18.5% |
| 0 | 11001 | 6.5% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 425350 |
Most frequent character per block
| Value | Count | Frequency (%) |
| 85070 | ||
| 6 | 42535 | |
| m | 42535 | |
| o | 42535 | |
| n | 42535 | |
| t | 42535 | |
| h | 42535 | |
| s | 42535 | |
| 3 | 31534 | 7.4% |
| 0 | 11001 | 2.6% |
| Distinct | 394 |
|---|---|
| Distinct (%) | 0.9% |
| Missing | 1 |
| Missing (%) | < 0.1% |
| Memory size | 332.4 KiB |
| 10.99% | 970 |
|---|---|
| 11.49% | 837 |
| 13.49% | 832 |
| 7.51% | 787 |
| 7.88% | 742 |
| Other values (389) |
Length
| Max length | 7 |
|---|---|
| Median length | 7 |
| Mean length | 7 |
| Min length | 7 |
Characters and Unicode
| Total characters | 297745 |
|---|---|
| Distinct characters | 13 |
| Distinct categories | 3 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 12 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | 10.65% |
|---|---|
| 2nd row | 15.27% |
| 3rd row | 15.96% |
| 4th row | 13.49% |
| 5th row | 12.69% |
| Value | Count | Frequency (%) |
| 10.99% | 970 | 2.3% |
| 11.49% | 837 | 2.0% |
| 13.49% | 832 | 2.0% |
| 7.51% | 787 | 1.9% |
| 7.88% | 742 | 1.7% |
| 7.49% | 656 | 1.5% |
| 11.71% | 609 | 1.4% |
| 9.99% | 607 | 1.4% |
| 7.90% | 582 | 1.4% |
| 5.42% | 573 | 1.3% |
| Other values (384) | 35340 |
| Value | Count | Frequency (%) |
| 10.99 | 970 | 2.3% |
| 11.49 | 837 | 2.0% |
| 13.49 | 832 | 2.0% |
| 7.51 | 787 | 1.9% |
| 7.88 | 742 | 1.7% |
| 7.49 | 656 | 1.5% |
| 11.71 | 609 | 1.4% |
| 9.99 | 607 | 1.4% |
| 7.90 | 582 | 1.4% |
| 5.42 | 573 | 1.3% |
| Other values (384) | 35340 |
Most occurring characters
| Value | Count | Frequency (%) |
| 54877 | ||
| . | 42535 | |
| % | 42535 | |
| 1 | 41594 | |
| 9 | 22648 | |
| 2 | 13727 | 4.6% |
| 6 | 12870 | 4.3% |
| 7 | 12841 | 4.3% |
| 4 | 12024 | 4.0% |
| 3 | 10961 | 3.7% |
| Other values (3) | 31133 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 157798 | |
| Other Punctuation | 85070 | |
| Space Separator | 54877 | 18.4% |
Most frequent character per category
| Value | Count | Frequency (%) |
| 1 | 41594 | |
| 9 | 22648 | |
| 2 | 13727 | 8.7% |
| 6 | 12870 | 8.2% |
| 7 | 12841 | 8.1% |
| 4 | 12024 | 7.6% |
| 3 | 10961 | 6.9% |
| 5 | 10910 | 6.9% |
| 8 | 10329 | 6.5% |
| 0 | 9894 | 6.3% |
| Value | Count | Frequency (%) |
| . | 42535 | |
| % | 42535 |
| Value | Count | Frequency (%) |
| 54877 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 297745 |
Most frequent character per script
| Value | Count | Frequency (%) |
| 54877 | ||
| . | 42535 | |
| % | 42535 | |
| 1 | 41594 | |
| 9 | 22648 | |
| 2 | 13727 | 4.6% |
| 6 | 12870 | 4.3% |
| 7 | 12841 | 4.3% |
| 4 | 12024 | 4.0% |
| 3 | 10961 | 3.7% |
| Other values (3) | 31133 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 297745 |
Most frequent character per block
| Value | Count | Frequency (%) |
| 54877 | ||
| . | 42535 | |
| % | 42535 | |
| 1 | 41594 | |
| 9 | 22648 | |
| 2 | 13727 | 4.6% |
| 6 | 12870 | 4.3% |
| 7 | 12841 | 4.3% |
| 4 | 12024 | 4.0% |
| 3 | 10961 | 3.7% |
| Other values (3) | 31133 |
| Distinct | 16459 |
|---|---|
| Distinct (%) | 38.7% |
| Missing | 1 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 322.6230627 |
|---|---|
| Minimum | 15.67 |
| Maximum | 1305.19 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 332.4 KiB |
Quantile statistics
| Minimum | 15.67 |
|---|---|
| 5-th percentile | 69.681 |
| Q1 | 165.52 |
| median | 277.69 |
| Q3 | 428.18 |
| 95-th percentile | 762.08 |
| Maximum | 1305.19 |
| Range | 1289.52 |
| Interquartile range (IQR) | 262.66 |
Descriptive statistics
| Standard deviation | 208.9272165 |
|---|---|
| Coefficient of variation (CV) | 0.6475892169 |
| Kurtosis | 1.20456977 |
| Mean | 322.6230627 |
| Median Absolute Deviation (MAD) | 122.18 |
| Skewness | 1.125240144 |
| Sum | 13722771.97 |
| Variance | 43650.58179 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) |
| 311.11 | 68 | 0.2% |
| 180.96 | 59 | 0.1% |
| 311.02 | 54 | 0.1% |
| 150.8 | 48 | 0.1% |
| 368.45 | 46 | 0.1% |
| 372.12 | 45 | 0.1% |
| 330.76 | 43 | 0.1% |
| 317.72 | 42 | 0.1% |
| 339.31 | 42 | 0.1% |
| 186.61 | 41 | 0.1% |
| Other values (16449) | 42047 |
| Value | Count | Frequency (%) |
| 15.67 | 1 | |
| 15.69 | 1 | |
| 15.75 | 1 | |
| 15.76 | 1 | |
| 15.91 | 1 |
| Value | Count | Frequency (%) |
| 1305.19 | 1 | |
| 1302.69 | 1 | |
| 1295.21 | 1 | |
| 1288.1 | 2 | |
| 1283.5 | 1 |
| Distinct | 7 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 1 |
| Missing (%) | < 0.1% |
| Memory size | 332.4 KiB |
| B | |
|---|---|
| A | |
| C | |
| D | |
| E | |
| Other values (2) |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 42535 |
|---|---|
| Distinct characters | 7 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | B |
|---|---|
| 2nd row | C |
| 3rd row | C |
| 4th row | C |
| 5th row | B |
| Value | Count | Frequency (%) |
| B | 12389 | |
| A | 10183 | |
| C | 8740 | |
| D | 6016 | |
| E | 3394 | 8.0% |
| F | 1301 | 3.1% |
| G | 512 | 1.2% |
| (Missing) | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| b | 12389 | |
| a | 10183 | |
| c | 8740 | |
| d | 6016 | |
| e | 3394 | 8.0% |
| f | 1301 | 3.1% |
| g | 512 | 1.2% |
Most occurring characters
| Value | Count | Frequency (%) |
| B | 12389 | |
| A | 10183 | |
| C | 8740 | |
| D | 6016 | |
| E | 3394 | 8.0% |
| F | 1301 | 3.1% |
| G | 512 | 1.2% |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 42535 |
Most frequent character per category
| Value | Count | Frequency (%) |
| B | 12389 | |
| A | 10183 | |
| C | 8740 | |
| D | 6016 | |
| E | 3394 | 8.0% |
| F | 1301 | 3.1% |
| G | 512 | 1.2% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 42535 |
Most frequent character per script
| Value | Count | Frequency (%) |
| B | 12389 | |
| A | 10183 | |
| C | 8740 | |
| D | 6016 | |
| E | 3394 | 8.0% |
| F | 1301 | 3.1% |
| G | 512 | 1.2% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 42535 |
Most frequent character per block
| Value | Count | Frequency (%) |
| B | 12389 | |
| A | 10183 | |
| C | 8740 | |
| D | 6016 | |
| E | 3394 | 8.0% |
| F | 1301 | 3.1% |
| G | 512 | 1.2% |
| Distinct | 35 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 1 |
| Missing (%) | < 0.1% |
| Memory size | 332.4 KiB |
| B3 | |
|---|---|
| A4 | |
| B5 | 2807 |
| A5 | 2793 |
| B4 | 2590 |
| Other values (30) |
Length
| Max length | 2 |
|---|---|
| Median length | 2 |
| Mean length | 2 |
| Min length | 2 |
Characters and Unicode
| Total characters | 85070 |
|---|---|
| Distinct characters | 12 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | B2 |
|---|---|
| 2nd row | C4 |
| 3rd row | C5 |
| 4th row | C1 |
| 5th row | B5 |
| Value | Count | Frequency (%) |
| B3 | 2997 | 7.0% |
| A4 | 2905 | 6.8% |
| B5 | 2807 | 6.6% |
| A5 | 2793 | 6.6% |
| B4 | 2590 | 6.1% |
| C1 | 2264 | 5.3% |
| C2 | 2157 | 5.1% |
| B2 | 2113 | 5.0% |
| B1 | 1882 | 4.4% |
| A3 | 1823 | 4.3% |
| Other values (25) | 18204 |
| Value | Count | Frequency (%) |
| b3 | 2997 | 7.0% |
| a4 | 2905 | 6.8% |
| b5 | 2807 | 6.6% |
| a5 | 2793 | 6.6% |
| b4 | 2590 | 6.1% |
| c1 | 2264 | 5.3% |
| c2 | 2157 | 5.1% |
| b2 | 2113 | 5.0% |
| b1 | 1882 | 4.4% |
| a3 | 1823 | 4.3% |
| Other values (25) | 18204 |
Most occurring characters
| Value | Count | Frequency (%) |
| B | 12389 | |
| A | 10183 | |
| 4 | 8867 | |
| 3 | 8783 | |
| C | 8740 | |
| 5 | 8646 | |
| 2 | 8481 | |
| 1 | 7758 | |
| D | 6016 | |
| E | 3394 | 4.0% |
| Other values (2) | 1813 | 2.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 42535 | |
| Decimal Number | 42535 |
Most frequent character per category
| Value | Count | Frequency (%) |
| B | 12389 | |
| A | 10183 | |
| C | 8740 | |
| D | 6016 | |
| E | 3394 | 8.0% |
| F | 1301 | 3.1% |
| G | 512 | 1.2% |
| Value | Count | Frequency (%) |
| 4 | 8867 | |
| 3 | 8783 | |
| 5 | 8646 | |
| 2 | 8481 | |
| 1 | 7758 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 42535 | |
| Common | 42535 |
Most frequent character per script
| Value | Count | Frequency (%) |
| B | 12389 | |
| A | 10183 | |
| C | 8740 | |
| D | 6016 | |
| E | 3394 | 8.0% |
| F | 1301 | 3.1% |
| G | 512 | 1.2% |
| Value | Count | Frequency (%) |
| 4 | 8867 | |
| 3 | 8783 | |
| 5 | 8646 | |
| 2 | 8481 | |
| 1 | 7758 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 85070 |
Most frequent character per block
| Value | Count | Frequency (%) |
| B | 12389 | |
| A | 10183 | |
| 4 | 8867 | |
| 3 | 8783 | |
| C | 8740 | |
| 5 | 8646 | |
| 2 | 8481 | |
| 1 | 7758 | |
| D | 6016 | |
| E | 3394 | 4.0% |
| Other values (2) | 1813 | 2.1% |
| Distinct | 30658 |
|---|---|
| Distinct (%) | 76.8% |
| Missing | 2627 |
| Missing (%) | 6.2% |
| Memory size | 332.4 KiB |
| US Army | 139 |
|---|---|
| Bank of America | 115 |
| IBM | 72 |
| AT&T | 61 |
| Kaiser Permanente | 61 |
| Other values (30653) |
Length
| Max length | 78 |
|---|---|
| Median length | 18 |
| Mean length | 18.34325591 |
| Min length | 2 |
Characters and Unicode
| Total characters | 732061 |
|---|---|
| Distinct characters | 96 |
| Distinct categories | 15 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 2 ? |
Unique
| Unique | 27187 ? |
|---|---|
| Unique (%) | 68.1% |
Sample
| 1st row | Ryder |
|---|---|
| 2nd row | AIR RESOURCES BOARD |
| 3rd row | University Medical Group |
| 4th row | Veolia Transportaton |
| 5th row | Southern Star Photography |
| Value | Count | Frequency (%) |
| US Army | 139 | 0.3% |
| Bank of America | 115 | 0.3% |
| IBM | 72 | 0.2% |
| AT&T | 61 | 0.1% |
| Kaiser Permanente | 61 | 0.1% |
| UPS | 58 | 0.1% |
| Wells Fargo | 57 | 0.1% |
| USAF | 56 | 0.1% |
| US Air Force | 55 | 0.1% |
| Self Employed | 49 | 0.1% |
| Other values (30648) | 39186 | |
| (Missing) | 2627 | 6.2% |
| Value | Count | Frequency (%) |
| inc | 3403 | 3.2% |
| of | 3200 | 3.0% |
| 1283 | 1.2% | |
| and | 1035 | 1.0% |
| services | 868 | 0.8% |
| center | 865 | 0.8% |
| bank | 850 | 0.8% |
| county | 846 | 0.8% |
| the | 797 | 0.7% |
| school | 794 | 0.7% |
| Other values (19749) | 93627 |
Most occurring characters
| Value | Count | Frequency (%) |
| 69179 | 9.4% | |
| e | 59921 | 8.2% |
| a | 46810 | 6.4% |
| n | 45589 | 6.2% |
| o | 45451 | 6.2% |
| i | 43260 | 5.9% |
| r | 42878 | 5.9% |
| t | 41183 | 5.6% |
| s | 32500 | 4.4% |
| l | 27700 | 3.8% |
| Other values (86) | 277590 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 523195 | |
| Uppercase Letter | 127793 | 17.5% |
| Space Separator | 69179 | 9.4% |
| Other Punctuation | 9393 | 1.3% |
| Dash Punctuation | 1098 | 0.1% |
| Decimal Number | 1026 | 0.1% |
| Open Punctuation | 172 | < 0.1% |
| Close Punctuation | 169 | < 0.1% |
| Math Symbol | 23 | < 0.1% |
| Currency Symbol | 3 | < 0.1% |
| Other values (5) | 10 | < 0.1% |
Most frequent character per category
| Value | Count | Frequency (%) |
| C | 15540 | 12.2% |
| S | 14246 | 11.1% |
| A | 9494 | 7.4% |
| I | 8073 | 6.3% |
| M | 6955 | 5.4% |
| P | 6470 | 5.1% |
| T | 6122 | 4.8% |
| L | 5978 | 4.7% |
| E | 5635 | 4.4% |
| D | 5406 | 4.2% |
| Other values (18) | 43874 |
| Value | Count | Frequency (%) |
| e | 59921 | |
| a | 46810 | |
| n | 45589 | |
| o | 45451 | |
| i | 43260 | 8.3% |
| r | 42878 | 8.2% |
| t | 41183 | 7.9% |
| s | 32500 | 6.2% |
| l | 27700 | 5.3% |
| c | 24704 | 4.7% |
| Other values (17) | 113199 |
| Value | Count | Frequency (%) |
| . | 4560 | |
| , | 2341 | |
| & | 1381 | 14.7% |
| ' | 688 | 7.3% |
| / | 334 | 3.6% |
| # | 37 | 0.4% |
| @ | 10 | 0.1% |
| ! | 9 | 0.1% |
| : | 9 | 0.1% |
| " | 8 | 0.1% |
| Other values (5) | 16 | 0.2% |
| Value | Count | Frequency (%) |
| 1 | 204 | |
| 2 | 170 | |
| 3 | 162 | |
| 0 | 105 | |
| 4 | 99 | |
| 5 | 75 | 7.3% |
| 9 | 68 | 6.6% |
| 6 | 61 | 5.9% |
| 7 | 47 | 4.6% |
| 8 | 35 | 3.4% |
| Value | Count | Frequency (%) |
| + | 20 | |
| | | 2 | 8.7% |
| < | 1 | 4.3% |
| Value | Count | Frequency (%) |
| ( | 171 | |
| [ | 1 | 0.6% |
| Value | Count | Frequency (%) |
| | 1 | |
| | 1 |
| Value | Count | Frequency (%) |
| $ | 2 | |
| ¢ | 1 |
| Value | Count | Frequency (%) |
| 69179 |
| Value | Count | Frequency (%) |
| - | 1098 |
| Value | Count | Frequency (%) |
| ) | 169 |
| Value | Count | Frequency (%) |
| © | 2 |
| Value | Count | Frequency (%) |
| ` | 2 |
| Value | Count | Frequency (%) |
| _ | 2 |
| Value | Count | Frequency (%) |
| ² | 2 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 650988 | |
| Common | 81073 | 11.1% |
Most frequent character per script
| Value | Count | Frequency (%) |
| e | 59921 | 9.2% |
| a | 46810 | 7.2% |
| n | 45589 | 7.0% |
| o | 45451 | 7.0% |
| i | 43260 | 6.6% |
| r | 42878 | 6.6% |
| t | 41183 | 6.3% |
| s | 32500 | 5.0% |
| l | 27700 | 4.3% |
| c | 24704 | 3.8% |
| Other values (45) | 240992 |
| Value | Count | Frequency (%) |
| 69179 | ||
| . | 4560 | 5.6% |
| , | 2341 | 2.9% |
| & | 1381 | 1.7% |
| - | 1098 | 1.4% |
| ' | 688 | 0.8% |
| / | 334 | 0.4% |
| 1 | 204 | 0.3% |
| ( | 171 | 0.2% |
| 2 | 170 | 0.2% |
| Other values (31) | 947 | 1.2% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 732047 | |
| None | 14 | < 0.1% |
Most frequent character per block
| Value | Count | Frequency (%) |
| 69179 | 9.5% | |
| e | 59921 | 8.2% |
| a | 46810 | 6.4% |
| n | 45589 | 6.2% |
| o | 45451 | 6.2% |
| i | 43260 | 5.9% |
| r | 42878 | 5.9% |
| t | 41183 | 5.6% |
| s | 32500 | 4.4% |
| l | 27700 | 3.8% |
| Other values (77) | 277576 |
| Value | Count | Frequency (%) |
| Ã | 3 | |
| © | 2 | |
| Â | 2 | |
| ² | 2 | |
| â | 1 | 7.1% |
| | 1 | 7.1% |
| ¢ | 1 | 7.1% |
| | 1 | 7.1% |
| ¡ | 1 | 7.1% |
| Distinct | 11 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 1113 |
| Missing (%) | 2.6% |
| Memory size | 332.4 KiB |
| 10+ years | |
|---|---|
| < 1 year | |
| 2 years | |
| 3 years | |
| 4 years | |
| Other values (6) |
Length
| Max length | 9 |
|---|---|
| Median length | 7 |
| Mean length | 7.487772494 |
| Min length | 6 |
Characters and Unicode
| Total characters | 310166 |
|---|---|
| Distinct characters | 18 |
| Distinct categories | 4 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 10+ years |
|---|---|
| 2nd row | < 1 year |
| 3rd row | 10+ years |
| 4th row | 10+ years |
| 5th row | 1 year |
| Value | Count | Frequency (%) |
| 10+ years | 9369 | |
| < 1 year | 5062 | |
| 2 years | 4743 | |
| 3 years | 4364 | |
| 4 years | 3649 | 8.6% |
| 1 year | 3595 | 8.5% |
| 5 years | 3458 | 8.1% |
| 6 years | 2375 | 5.6% |
| 7 years | 1875 | 4.4% |
| 8 years | 1592 | 3.7% |
| Value | Count | Frequency (%) |
| years | 32766 | |
| 10 | 9369 | 10.7% |
| 1 | 8657 | 9.8% |
| year | 8657 | 9.8% |
| 5062 | 5.8% | |
| 2 | 4743 | 5.4% |
| 3 | 4364 | 5.0% |
| 4 | 3649 | 4.2% |
| 5 | 3458 | 3.9% |
| 6 | 2375 | 2.7% |
| Other values (3) | 4808 | 5.5% |
Most occurring characters
| Value | Count | Frequency (%) |
| 46485 | ||
| y | 41423 | |
| e | 41423 | |
| a | 41423 | |
| r | 41423 | |
| s | 32766 | |
| 1 | 18026 | 5.8% |
| 0 | 9369 | 3.0% |
| + | 9369 | 3.0% |
| < | 5062 | 1.6% |
| Other values (8) | 23397 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 198458 | |
| Decimal Number | 50792 | 16.4% |
| Space Separator | 46485 | 15.0% |
| Math Symbol | 14431 | 4.7% |
Most frequent character per category
| Value | Count | Frequency (%) |
| 1 | 18026 | |
| 0 | 9369 | |
| 2 | 4743 | 9.3% |
| 3 | 4364 | 8.6% |
| 4 | 3649 | 7.2% |
| 5 | 3458 | 6.8% |
| 6 | 2375 | 4.7% |
| 7 | 1875 | 3.7% |
| 8 | 1592 | 3.1% |
| 9 | 1341 | 2.6% |
| Value | Count | Frequency (%) |
| y | 41423 | |
| e | 41423 | |
| a | 41423 | |
| r | 41423 | |
| s | 32766 |
| Value | Count | Frequency (%) |
| + | 9369 | |
| < | 5062 |
| Value | Count | Frequency (%) |
| 46485 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 198458 | |
| Common | 111708 |
Most frequent character per script
| Value | Count | Frequency (%) |
| 46485 | ||
| 1 | 18026 | 16.1% |
| 0 | 9369 | 8.4% |
| + | 9369 | 8.4% |
| < | 5062 | 4.5% |
| 2 | 4743 | 4.2% |
| 3 | 4364 | 3.9% |
| 4 | 3649 | 3.3% |
| 5 | 3458 | 3.1% |
| 6 | 2375 | 2.1% |
| Other values (3) | 4808 | 4.3% |
| Value | Count | Frequency (%) |
| y | 41423 | |
| e | 41423 | |
| a | 41423 | |
| r | 41423 | |
| s | 32766 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 310166 |
Most frequent character per block
| Value | Count | Frequency (%) |
| 46485 | ||
| y | 41423 | |
| e | 41423 | |
| a | 41423 | |
| r | 41423 | |
| s | 32766 | |
| 1 | 18026 | 5.8% |
| 0 | 9369 | 3.0% |
| + | 9369 | 3.0% |
| < | 5062 | 1.6% |
| Other values (8) | 23397 |
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 1 |
| Missing (%) | < 0.1% |
| Memory size | 332.4 KiB |
| RENT | |
|---|---|
| MORTGAGE | |
| OWN | |
| OTHER | 136 |
| NONE | 8 |
Length
| Max length | 8 |
|---|---|
| Median length | 4 |
| Mean length | 5.709674386 |
| Min length | 3 |
Characters and Unicode
| Total characters | 242861 |
|---|---|
| Distinct characters | 10 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | RENT |
|---|---|
| 2nd row | RENT |
| 3rd row | RENT |
| 4th row | RENT |
| 5th row | RENT |
| Value | Count | Frequency (%) |
| RENT | 20181 | |
| MORTGAGE | 18959 | |
| OWN | 3251 | 7.6% |
| OTHER | 136 | 0.3% |
| NONE | 8 | < 0.1% |
| (Missing) | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| rent | 20181 | |
| mortgage | 18959 | |
| own | 3251 | 7.6% |
| other | 136 | 0.3% |
| none | 8 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| E | 39284 | |
| R | 39276 | |
| T | 39276 | |
| G | 37918 | |
| N | 23448 | |
| O | 22354 | |
| M | 18959 | |
| A | 18959 | |
| W | 3251 | 1.3% |
| H | 136 | 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 242861 |
Most frequent character per category
| Value | Count | Frequency (%) |
| E | 39284 | |
| R | 39276 | |
| T | 39276 | |
| G | 37918 | |
| N | 23448 | |
| O | 22354 | |
| M | 18959 | |
| A | 18959 | |
| W | 3251 | 1.3% |
| H | 136 | 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 242861 |
Most frequent character per script
| Value | Count | Frequency (%) |
| E | 39284 | |
| R | 39276 | |
| T | 39276 | |
| G | 37918 | |
| N | 23448 | |
| O | 22354 | |
| M | 18959 | |
| A | 18959 | |
| W | 3251 | 1.3% |
| H | 136 | 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 242861 |
Most frequent character per block
| Value | Count | Frequency (%) |
| E | 39284 | |
| R | 39276 | |
| T | 39276 | |
| G | 37918 | |
| N | 23448 | |
| O | 22354 | |
| M | 18959 | |
| A | 18959 | |
| W | 3251 | 1.3% |
| H | 136 | 0.1% |
| Distinct | 5597 |
|---|---|
| Distinct (%) | 13.2% |
| Missing | 5 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 69136.55642 |
|---|---|
| Minimum | 1896 |
| Maximum | 6000000 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 332.4 KiB |
Quantile statistics
| Minimum | 1896 |
|---|---|
| 5-th percentile | 24000 |
| Q1 | 40000 |
| median | 59000 |
| Q3 | 82500 |
| 95-th percentile | 144000 |
| Maximum | 6000000 |
| Range | 5998104 |
| Interquartile range (IQR) | 42500 |
Descriptive statistics
| Standard deviation | 64096.34972 |
|---|---|
| Coefficient of variation (CV) | 0.9270978052 |
| Kurtosis | 2117.344597 |
| Mean | 69136.55642 |
| Median Absolute Deviation (MAD) | 20000 |
| Skewness | 29.03489277 |
| Sum | 2940446881 |
| Variance | 4108342047 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) |
| 60000 | 1591 | 3.7% |
| 50000 | 1119 | 2.6% |
| 40000 | 935 | 2.2% |
| 45000 | 898 | 2.1% |
| 30000 | 884 | 2.1% |
| 75000 | 865 | 2.0% |
| 65000 | 840 | 2.0% |
| 70000 | 790 | 1.9% |
| 48000 | 766 | 1.8% |
| 80000 | 718 | 1.7% |
| Other values (5587) | 33125 |
| Value | Count | Frequency (%) |
| 1896 | 1 | |
| 2000 | 1 | |
| 3300 | 1 | |
| 3500 | 1 | |
| 3600 | 1 |
| Value | Count | Frequency (%) |
| 6000000 | 1 | |
| 3900000 | 1 | |
| 2039784 | 1 | |
| 1900000 | 1 | |
| 1782000 | 1 |
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 1 |
| Missing (%) | < 0.1% |
| Memory size | 332.4 KiB |
| Not Verified | |
|---|---|
| Verified | |
| Source Verified |
Length
| Max length | 15 |
|---|---|
| Median length | 12 |
| Mean length | 11.46006818 |
| Min length | 8 |
Characters and Unicode
| Total characters | 487454 |
|---|---|
| Distinct characters | 13 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Verified |
|---|---|
| 2nd row | Source Verified |
| 3rd row | Not Verified |
| 4th row | Source Verified |
| 5th row | Source Verified |
| Value | Count | Frequency (%) |
| Not Verified | 18758 | |
| Verified | 13471 | |
| Source Verified | 10306 | |
| (Missing) | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| verified | 42535 | |
| not | 18758 | |
| source | 10306 | 14.4% |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 95376 | |
| i | 85070 | |
| r | 52841 | |
| V | 42535 | |
| f | 42535 | |
| d | 42535 | |
| o | 29064 | 6.0% |
| 29064 | 6.0% | |
| N | 18758 | 3.8% |
| t | 18758 | 3.8% |
| Other values (3) | 30918 | 6.3% |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 386791 | |
| Uppercase Letter | 71599 | 14.7% |
| Space Separator | 29064 | 6.0% |
Most frequent character per category
| Value | Count | Frequency (%) |
| e | 95376 | |
| i | 85070 | |
| r | 52841 | |
| f | 42535 | |
| d | 42535 | |
| o | 29064 | 7.5% |
| t | 18758 | 4.8% |
| u | 10306 | 2.7% |
| c | 10306 | 2.7% |
| Value | Count | Frequency (%) |
| V | 42535 | |
| N | 18758 | |
| S | 10306 | 14.4% |
| Value | Count | Frequency (%) |
| 29064 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 458390 | |
| Common | 29064 | 6.0% |
Most frequent character per script
| Value | Count | Frequency (%) |
| e | 95376 | |
| i | 85070 | |
| r | 52841 | |
| V | 42535 | |
| f | 42535 | |
| d | 42535 | |
| o | 29064 | 6.3% |
| N | 18758 | 4.1% |
| t | 18758 | 4.1% |
| S | 10306 | 2.2% |
| Other values (2) | 20612 | 4.5% |
| Value | Count | Frequency (%) |
| 29064 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 487454 |
Most frequent character per block
| Value | Count | Frequency (%) |
| e | 95376 | |
| i | 85070 | |
| r | 52841 | |
| V | 42535 | |
| f | 42535 | |
| d | 42535 | |
| o | 29064 | 6.0% |
| 29064 | 6.0% | |
| N | 18758 | 3.8% |
| t | 18758 | 3.8% |
| Other values (3) | 30918 | 6.3% |
| Distinct | 55 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 1 |
| Missing (%) | < 0.1% |
| Memory size | 332.4 KiB |
| Dec-2011 | 2267 |
|---|---|
| Nov-2011 | 2232 |
| Oct-2011 | 2118 |
| Sep-2011 | 2067 |
| Aug-2011 | 1934 |
| Other values (50) |
Length
| Max length | 8 |
|---|---|
| Median length | 8 |
| Mean length | 8 |
| Min length | 8 |
Characters and Unicode
| Total characters | 340280 |
|---|---|
| Distinct characters | 29 |
| Distinct categories | 4 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Dec-2011 |
|---|---|
| 2nd row | Dec-2011 |
| 3rd row | Dec-2011 |
| 4th row | Dec-2011 |
| 5th row | Dec-2011 |
| Value | Count | Frequency (%) |
| Dec-2011 | 2267 | 5.3% |
| Nov-2011 | 2232 | 5.2% |
| Oct-2011 | 2118 | 5.0% |
| Sep-2011 | 2067 | 4.9% |
| Aug-2011 | 1934 | 4.5% |
| Jul-2011 | 1875 | 4.4% |
| Jun-2011 | 1835 | 4.3% |
| May-2011 | 1704 | 4.0% |
| Apr-2011 | 1563 | 3.7% |
| Mar-2011 | 1448 | 3.4% |
| Other values (45) | 23492 |
| Value | Count | Frequency (%) |
| dec-2011 | 2267 | 5.3% |
| nov-2011 | 2232 | 5.2% |
| oct-2011 | 2118 | 5.0% |
| sep-2011 | 2067 | 4.9% |
| aug-2011 | 1934 | 4.5% |
| jul-2011 | 1875 | 4.4% |
| jun-2011 | 1835 | 4.3% |
| may-2011 | 1704 | 4.0% |
| apr-2011 | 1563 | 3.7% |
| mar-2011 | 1448 | 3.4% |
| Other values (45) | 23492 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 63349 | |
| 1 | 55979 | |
| - | 42535 | |
| 2 | 42535 | |
| e | 11146 | 3.3% |
| u | 10917 | 3.2% |
| J | 9804 | 2.9% |
| c | 8866 | 2.6% |
| a | 8785 | 2.6% |
| p | 6940 | 2.0% |
| Other values (19) | 79424 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 170140 | |
| Lowercase Letter | 85070 | |
| Uppercase Letter | 42535 | 12.5% |
| Dash Punctuation | 42535 | 12.5% |
Most frequent character per category
| Value | Count | Frequency (%) |
| e | 11146 | |
| u | 10917 | |
| c | 8866 | |
| a | 8785 | |
| p | 6940 | |
| n | 6110 | |
| r | 6069 | |
| o | 4439 | 5.2% |
| v | 4439 | 5.2% |
| t | 4181 | 4.9% |
| Other values (4) | 13178 |
| Value | Count | Frequency (%) |
| J | 9804 | |
| A | 6796 | |
| M | 6169 | |
| D | 4685 | |
| N | 4439 | |
| O | 4181 | |
| S | 3873 | 9.1% |
| F | 2588 | 6.1% |
| Value | Count | Frequency (%) |
| 0 | 63349 | |
| 1 | 55979 | |
| 2 | 42535 | |
| 9 | 5281 | 3.1% |
| 8 | 2393 | 1.4% |
| 7 | 603 | 0.4% |
| Value | Count | Frequency (%) |
| - | 42535 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 212675 | |
| Latin | 127605 |
Most frequent character per script
| Value | Count | Frequency (%) |
| e | 11146 | 8.7% |
| u | 10917 | 8.6% |
| J | 9804 | 7.7% |
| c | 8866 | 6.9% |
| a | 8785 | 6.9% |
| p | 6940 | 5.4% |
| A | 6796 | 5.3% |
| M | 6169 | 4.8% |
| n | 6110 | 4.8% |
| r | 6069 | 4.8% |
| Other values (12) | 46003 |
| Value | Count | Frequency (%) |
| 0 | 63349 | |
| 1 | 55979 | |
| - | 42535 | |
| 2 | 42535 | |
| 9 | 5281 | 2.5% |
| 8 | 2393 | 1.1% |
| 7 | 603 | 0.3% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 340280 |
Most frequent character per block
| Value | Count | Frequency (%) |
| 0 | 63349 | |
| 1 | 55979 | |
| - | 42535 | |
| 2 | 42535 | |
| e | 11146 | 3.3% |
| u | 10917 | 3.2% |
| J | 9804 | 2.9% |
| c | 8866 | 2.6% |
| a | 8785 | 2.6% |
| p | 6940 | 2.0% |
| Other values (19) | 79424 |
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 1 |
| Missing (%) | < 0.1% |
| Memory size | 332.4 KiB |
| Fully Paid | |
|---|---|
| Charged Off | |
| Does not meet the credit policy. Status:Fully Paid | 1988 |
| Does not meet the credit policy. Status:Charged Off | 761 |
Length
| Max length | 51 |
|---|---|
| Median length | 10 |
| Mean length | 12.73635829 |
| Min length | 10 |
Characters and Unicode
| Total characters | 541741 |
|---|---|
| Distinct characters | 27 |
| Distinct categories | 4 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Fully Paid |
|---|---|
| 2nd row | Charged Off |
| 3rd row | Fully Paid |
| 4th row | Fully Paid |
| 5th row | Fully Paid |
| Value | Count | Frequency (%) |
| Fully Paid | 34116 | |
| Charged Off | 5670 | 13.3% |
| Does not meet the credit policy. Status:Fully Paid | 1988 | 4.7% |
| Does not meet the credit policy. Status:Charged Off | 761 | 1.8% |
| (Missing) | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| paid | 36104 | |
| fully | 34116 | |
| off | 6431 | 6.3% |
| charged | 5670 | 5.6% |
| credit | 2749 | 2.7% |
| meet | 2749 | 2.7% |
| the | 2749 | 2.7% |
| policy | 2749 | 2.7% |
| not | 2749 | 2.7% |
| does | 2749 | 2.7% |
| Other values (2) | 2749 | 2.7% |
Most occurring characters
| Value | Count | Frequency (%) |
| l | 74957 | |
| 59029 | ||
| a | 45284 | |
| d | 45284 | |
| i | 41602 | 7.7% |
| u | 38853 | 7.2% |
| y | 38853 | 7.2% |
| F | 36104 | 6.7% |
| P | 36104 | 6.7% |
| e | 20176 | 3.7% |
| Other values (17) | 105495 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 386646 | |
| Uppercase Letter | 90568 | 16.7% |
| Space Separator | 59029 | 10.9% |
| Other Punctuation | 5498 | 1.0% |
Most frequent character per category
| Value | Count | Frequency (%) |
| l | 74957 | |
| a | 45284 | |
| d | 45284 | |
| i | 41602 | |
| u | 38853 | |
| y | 38853 | |
| e | 20176 | 5.2% |
| t | 16494 | 4.3% |
| f | 12862 | 3.3% |
| h | 9180 | 2.4% |
| Other values (8) | 43101 |
| Value | Count | Frequency (%) |
| F | 36104 | |
| P | 36104 | |
| C | 6431 | 7.1% |
| O | 6431 | 7.1% |
| D | 2749 | 3.0% |
| S | 2749 | 3.0% |
| Value | Count | Frequency (%) |
| . | 2749 | |
| : | 2749 |
| Value | Count | Frequency (%) |
| 59029 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 477214 | |
| Common | 64527 | 11.9% |
Most frequent character per script
| Value | Count | Frequency (%) |
| l | 74957 | |
| a | 45284 | |
| d | 45284 | |
| i | 41602 | |
| u | 38853 | |
| y | 38853 | |
| F | 36104 | |
| P | 36104 | |
| e | 20176 | 4.2% |
| t | 16494 | 3.5% |
| Other values (14) | 83503 |
| Value | Count | Frequency (%) |
| 59029 | ||
| . | 2749 | 4.3% |
| : | 2749 | 4.3% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 541741 |
Most frequent character per block
| Value | Count | Frequency (%) |
| l | 74957 | |
| 59029 | ||
| a | 45284 | |
| d | 45284 | |
| i | 41602 | 7.7% |
| u | 38853 | 7.2% |
| y | 38853 | 7.2% |
| F | 36104 | 6.7% |
| P | 36104 | 6.7% |
| e | 20176 | 3.7% |
| Other values (17) | 105495 |
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 1 |
| Missing (%) | < 0.1% |
| Memory size | 83.2 KiB |
| False | |
|---|---|
| (Missing) | 1 |
| Value | Count | Frequency (%) |
| False | 42535 | |
| (Missing) | 1 | < 0.1% |
| Distinct | 42535 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 1 |
| Missing (%) | < 0.1% |
| Memory size | 332.4 KiB |
| https://lendingclub.com/browse/loanDetail.action?loan_id=460307 | 1 |
|---|---|
| https://lendingclub.com/browse/loanDetail.action?loan_id=483102 | 1 |
| https://lendingclub.com/browse/loanDetail.action?loan_id=764195 | 1 |
| https://lendingclub.com/browse/loanDetail.action?loan_id=993479 | 1 |
| https://lendingclub.com/browse/loanDetail.action?loan_id=1049647 | 1 |
| Other values (42530) |
Length
| Max length | 64 |
|---|---|
| Median length | 63 |
| Mean length | 63.10008229 |
| Min length | 62 |
Characters and Unicode
| Total characters | 2683962 |
|---|---|
| Distinct characters | 35 |
| Distinct categories | 6 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 42535 ? |
|---|---|
| Unique (%) | 100.0% |
Sample
| 1st row | https://lendingclub.com/browse/loanDetail.action?loan_id=1077501 |
|---|---|
| 2nd row | https://lendingclub.com/browse/loanDetail.action?loan_id=1077430 |
| 3rd row | https://lendingclub.com/browse/loanDetail.action?loan_id=1077175 |
| 4th row | https://lendingclub.com/browse/loanDetail.action?loan_id=1076863 |
| 5th row | https://lendingclub.com/browse/loanDetail.action?loan_id=1075358 |
| Value | Count | Frequency (%) |
| https://lendingclub.com/browse/loanDetail.action?loan_id=460307 | 1 | < 0.1% |
| https://lendingclub.com/browse/loanDetail.action?loan_id=483102 | 1 | < 0.1% |
| https://lendingclub.com/browse/loanDetail.action?loan_id=764195 | 1 | < 0.1% |
| https://lendingclub.com/browse/loanDetail.action?loan_id=993479 | 1 | < 0.1% |
| https://lendingclub.com/browse/loanDetail.action?loan_id=1049647 | 1 | < 0.1% |
| https://lendingclub.com/browse/loanDetail.action?loan_id=633056 | 1 | < 0.1% |
| https://lendingclub.com/browse/loanDetail.action?loan_id=750212 | 1 | < 0.1% |
| https://lendingclub.com/browse/loanDetail.action?loan_id=756297 | 1 | < 0.1% |
| https://lendingclub.com/browse/loanDetail.action?loan_id=888556 | 1 | < 0.1% |
| https://lendingclub.com/browse/loanDetail.action?loan_id=868759 | 1 | < 0.1% |
| Other values (42525) | 42525 |
| Value | Count | Frequency (%) |
| https://lendingclub.com/browse/loandetail.action?loan_id=503393 | 1 | < 0.1% |
| https://lendingclub.com/browse/loandetail.action?loan_id=347228 | 1 | < 0.1% |
| https://lendingclub.com/browse/loandetail.action?loan_id=674225 | 1 | < 0.1% |
| https://lendingclub.com/browse/loandetail.action?loan_id=363367 | 1 | < 0.1% |
| https://lendingclub.com/browse/loandetail.action?loan_id=539607 | 1 | < 0.1% |
| https://lendingclub.com/browse/loandetail.action?loan_id=565387 | 1 | < 0.1% |
| https://lendingclub.com/browse/loandetail.action?loan_id=747483 | 1 | < 0.1% |
| https://lendingclub.com/browse/loandetail.action?loan_id=365927 | 1 | < 0.1% |
| https://lendingclub.com/browse/loandetail.action?loan_id=1014573 | 1 | < 0.1% |
| https://lendingclub.com/browse/loandetail.action?loan_id=414134 | 1 | < 0.1% |
| Other values (42525) | 42525 |
Most occurring characters
| Value | Count | Frequency (%) |
| l | 212675 | 7.9% |
| n | 212675 | 7.9% |
| o | 212675 | 7.9% |
| t | 170140 | 6.3% |
| / | 170140 | 6.3% |
| i | 170140 | 6.3% |
| a | 170140 | 6.3% |
| e | 127605 | 4.8% |
| c | 127605 | 4.8% |
| s | 85070 | 3.2% |
| Other values (25) | 1025097 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 1956610 | |
| Other Punctuation | 340280 | 12.7% |
| Decimal Number | 259467 | 9.7% |
| Uppercase Letter | 42535 | 1.6% |
| Connector Punctuation | 42535 | 1.6% |
| Math Symbol | 42535 | 1.6% |
Most frequent character per category
| Value | Count | Frequency (%) |
| l | 212675 | |
| n | 212675 | |
| o | 212675 | |
| t | 170140 | |
| i | 170140 | |
| a | 170140 | |
| e | 127605 | 6.5% |
| c | 127605 | 6.5% |
| s | 85070 | 4.3% |
| d | 85070 | 4.3% |
| Other values (8) | 382815 |
| Value | Count | Frequency (%) |
| 5 | 28614 | |
| 6 | 28238 | |
| 4 | 27659 | |
| 7 | 27532 | |
| 8 | 27202 | |
| 1 | 25851 | |
| 0 | 25228 | |
| 3 | 24043 | |
| 9 | 23116 | |
| 2 | 21984 |
| Value | Count | Frequency (%) |
| / | 170140 | |
| . | 85070 | |
| : | 42535 | 12.5% |
| ? | 42535 | 12.5% |
| Value | Count | Frequency (%) |
| D | 42535 |
| Value | Count | Frequency (%) |
| _ | 42535 |
| Value | Count | Frequency (%) |
| = | 42535 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 1999145 | |
| Common | 684817 | 25.5% |
Most frequent character per script
| Value | Count | Frequency (%) |
| l | 212675 | |
| n | 212675 | |
| o | 212675 | |
| t | 170140 | 8.5% |
| i | 170140 | 8.5% |
| a | 170140 | 8.5% |
| e | 127605 | 6.4% |
| c | 127605 | 6.4% |
| s | 85070 | 4.3% |
| d | 85070 | 4.3% |
| Other values (9) | 425350 |
| Value | Count | Frequency (%) |
| / | 170140 | |
| . | 85070 | |
| : | 42535 | 6.2% |
| ? | 42535 | 6.2% |
| _ | 42535 | 6.2% |
| = | 42535 | 6.2% |
| 5 | 28614 | 4.2% |
| 6 | 28238 | 4.1% |
| 4 | 27659 | 4.0% |
| 7 | 27532 | 4.0% |
| Other values (6) | 147424 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 2683962 |
Most frequent character per block
| Value | Count | Frequency (%) |
| l | 212675 | 7.9% |
| n | 212675 | 7.9% |
| o | 212675 | 7.9% |
| t | 170140 | 6.3% |
| / | 170140 | 6.3% |
| i | 170140 | 6.3% |
| a | 170140 | 6.3% |
| e | 127605 | 4.8% |
| c | 127605 | 4.8% |
| s | 85070 | 3.2% |
| Other values (25) | 1025097 |
| Distinct | 28963 |
|---|---|
| Distinct (%) | 99.0% |
| Missing | 13294 |
| Missing (%) | 31.3% |
| Memory size | 332.4 KiB |
| 225 | |
| Debt Consolidation | 11 |
| Camping Membership | 8 |
| refinancing | 5 |
| credit card consolidation | 3 |
| Other values (28958) |
Length
| Max length | 3988 |
|---|---|
| Median length | 281 |
| Mean length | 423.4260311 |
| Min length | 1 |
Characters and Unicode
| Total characters | 12381824 |
|---|---|
| Distinct characters | 142 |
| Distinct categories | 17 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 4 ? |
Unique
| Unique | 28931 ? |
|---|---|
| Unique (%) | 98.9% |
Sample
| 1st row | Borrower added on 12/22/11 > I need to upgrade my business technologies.<br> |
|---|---|
| 2nd row | Borrower added on 12/22/11 > I plan to use this money to finance the motorcycle i am looking at. I plan to have it paid off as soon as possible/when i sell my old bike. I only need this money because the deal im looking at is to good to pass up.<br><br> Borrower added on 12/22/11 > I plan to use this money to finance the motorcycle i am looking at. I plan to have it paid off as soon as possible/when i sell my old bike.I only need this money because the deal im looking at is to good to pass up. I have finished college with an associates degree in business and its takingmeplaces<br> |
| 3rd row | Borrower added on 12/21/11 > to pay for property tax (borrow from friend, need to pay back) & central A/C need to be replace. I'm very sorry to let my loan expired last time.<br> |
| 4th row | Borrower added on 12/21/11 > I plan on combining three large interest bills together and freeing up some extra each month to pay toward other bills. I've always been a good payor but have found myself needing to make adjustments to my budget due to a medical scare. My job is very stable, I love it.<br> |
| 5th row | Borrower added on 12/18/11 > I am planning on using the funds to pay off two retail credit cards with 24.99% interest rates, as well as a major bank credit card with a 18.99% rate. I pay all my bills on time, looking for a lower combined payment and lower monthly payment.<br> |
| Value | Count | Frequency (%) |
| 225 | 0.5% | |
| Debt Consolidation | 11 | < 0.1% |
| Camping Membership | 8 | < 0.1% |
| refinancing | 5 | < 0.1% |
| credit card consolidation | 3 | < 0.1% |
| consolidate debt | 3 | < 0.1% |
| personal loan | 3 | < 0.1% |
| credit card debt consolidation | 3 | < 0.1% |
| Personal Loan | 3 | < 0.1% |
| debt consolidation | 3 | < 0.1% |
| Other values (28953) | 28975 | |
| (Missing) | 13294 |
| Value | Count | Frequency (%) |
| i | 85087 | 3.8% |
| to | 77670 | 3.5% |
| a | 60001 | 2.7% |
| and | 59305 | 2.7% |
| the | 59159 | 2.7% |
| my | 55839 | 2.5% |
| on | 51981 | 2.3% |
| 39157 | 1.8% | |
| for | 35488 | 1.6% |
| have | 35150 | 1.6% |
| Other values (56778) | 1668318 |
Most occurring characters
| Value | Count | Frequency (%) |
| 2303677 | ||
| e | 1036186 | 8.4% |
| a | 775912 | 6.3% |
| o | 767722 | 6.2% |
| t | 707444 | 5.7% |
| n | 664469 | 5.4% |
| r | 634406 | 5.1% |
| i | 540140 | 4.4% |
| s | 464080 | 3.7% |
| d | 428929 | 3.5% |
| Other values (132) | 4058859 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 8832480 | |
| Space Separator | 2303751 | 18.6% |
| Decimal Number | 368643 | 3.0% |
| Other Punctuation | 350646 | 2.8% |
| Uppercase Letter | 329296 | 2.7% |
| Math Symbol | 146513 | 1.2% |
| Currency Symbol | 18187 | 0.1% |
| Dash Punctuation | 14304 | 0.1% |
| Close Punctuation | 7970 | 0.1% |
| Open Punctuation | 7305 | 0.1% |
| Other values (7) | 2729 | < 0.1% |
Most frequent character per category
| Value | Count | Frequency (%) |
| I | 103385 | |
| B | 36481 | 11.1% |
| T | 30887 | 9.4% |
| A | 17040 | 5.2% |
| M | 15514 | 4.7% |
| C | 15439 | 4.7% |
| S | 10680 | 3.2% |
| E | 10134 | 3.1% |
| W | 9701 | 2.9% |
| L | 9398 | 2.9% |
| Other values (21) | 70637 |
| Value | Count | Frequency (%) |
| e | 1036186 | |
| a | 775912 | 8.8% |
| o | 767722 | 8.7% |
| t | 707444 | 8.0% |
| n | 664469 | 7.5% |
| r | 634406 | 7.2% |
| i | 540140 | 6.1% |
| s | 464080 | 5.3% |
| d | 428929 | 4.9% |
| l | 386876 | 4.4% |
| Other values (18) | 2426316 |
| Value | Count | Frequency (%) |
| . | 131381 | |
| / | 121672 | |
| , | 54749 | |
| ' | 14495 | 4.1% |
| ! | 7335 | 2.1% |
| % | 6191 | 1.8% |
| : | 5814 | 1.7% |
| ; | 3493 | 1.0% |
| & | 2753 | 0.8% |
| " | 925 | 0.3% |
| Other values (10) | 1838 | 0.5% |
| Value | Count | Frequency (%) |
| 1318 | ||
| | 426 | 19.5% |
| | 200 | 9.1% |
| | 38 | 1.7% |
| | 38 | 1.7% |
| | 35 | 1.6% |
| | 29 | 1.3% |
| | 27 | 1.2% |
| | 25 | 1.1% |
| | 15 | 0.7% |
| Other values (9) | 39 | 1.8% |
| Value | Count | Frequency (%) |
| 0 | 111941 | |
| 1 | 101613 | |
| 2 | 39139 | 10.6% |
| 5 | 23226 | 6.3% |
| 3 | 19094 | 5.2% |
| 9 | 17472 | 4.7% |
| 4 | 14581 | 4.0% |
| 6 | 14099 | 3.8% |
| 7 | 13782 | 3.7% |
| 8 | 13696 | 3.7% |
| Value | Count | Frequency (%) |
| > | 88381 | |
| < | 56071 | |
| + | 1055 | 0.7% |
| = | 647 | 0.4% |
| ~ | 318 | 0.2% |
| ¬ | 31 | < 0.1% |
| | | 10 | < 0.1% |
| Value | Count | Frequency (%) |
| ¦ | 97 | |
| © | 15 | 12.4% |
| � | 7 | 5.8% |
| ® | 2 | 1.7% |
| Value | Count | Frequency (%) |
| ( | 7258 | |
| [ | 44 | 0.6% |
| { | 3 | < 0.1% |
| Value | Count | Frequency (%) |
| ) | 7922 | |
| ] | 44 | 0.6% |
| } | 4 | 0.1% |
| Value | Count | Frequency (%) |
| - | 14285 | |
| – | 10 | 0.1% |
| — | 9 | 0.1% |
| Value | Count | Frequency (%) |
| ` | 13 | |
| ^ | 5 | 26.3% |
| ¯ | 1 | 5.3% |
| Value | Count | Frequency (%) |
| 2303677 | ||
| 74 | < 0.1% |
| Value | Count | Frequency (%) |
| $ | 18113 | |
| ¢ | 74 | 0.4% |
| Value | Count | Frequency (%) |
| ½ | 7 | |
| ¾ | 2 | 22.2% |
| Value | Count | Frequency (%) |
| ’ | 90 | |
| ” | 18 | 16.7% |
| Value | Count | Frequency (%) |
| “ | 18 | |
| ‘ | 3 | 14.3% |
| Value | Count | Frequency (%) |
| _ | 261 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 9161776 | |
| Common | 3220048 | 26.0% |
Most frequent character per script
| Value | Count | Frequency (%) |
| 2303677 | ||
| . | 131381 | 4.1% |
| / | 121672 | 3.8% |
| 0 | 111941 | 3.5% |
| 1 | 101613 | 3.2% |
| > | 88381 | 2.7% |
| < | 56071 | 1.7% |
| , | 54749 | 1.7% |
| 2 | 39139 | 1.2% |
| 5 | 23226 | 0.7% |
| Other values (73) | 188198 | 5.8% |
| Value | Count | Frequency (%) |
| e | 1036186 | 11.3% |
| a | 775912 | 8.5% |
| o | 767722 | 8.4% |
| t | 707444 | 7.7% |
| n | 664469 | 7.3% |
| r | 634406 | 6.9% |
| i | 540140 | 5.9% |
| s | 464080 | 5.1% |
| d | 428929 | 4.7% |
| l | 386876 | 4.2% |
| Other values (49) | 2755612 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 12379753 | |
| None | 1886 | < 0.1% |
| Punctuation | 178 | < 0.1% |
| Specials | 7 | < 0.1% |
Most frequent character per block
| Value | Count | Frequency (%) |
| 2303677 | ||
| e | 1036186 | 8.4% |
| a | 775912 | 6.3% |
| o | 767722 | 6.2% |
| t | 707444 | 5.7% |
| n | 664469 | 5.4% |
| r | 634406 | 5.1% |
| i | 540140 | 4.4% |
| s | 464080 | 3.7% |
| d | 428929 | 3.5% |
| Other values (86) | 4056788 |
| Value | Count | Frequency (%) |
| â | 453 | |
| | 426 | |
| | 200 | |
| Â | 128 | 6.8% |
| Ã | 97 | 5.1% |
| ¦ | 97 | 5.1% |
| ¢ | 74 | 3.9% |
| 74 | 3.9% | |
| | 38 | 2.0% |
| | 38 | 2.0% |
| Other values (27) | 261 |
| Value | Count | Frequency (%) |
| ’ | 90 | |
| … | 22 | 12.4% |
| “ | 18 | 10.1% |
| ” | 18 | 10.1% |
| – | 10 | 5.6% |
| — | 9 | 5.1% |
| • | 8 | 4.5% |
| ‘ | 3 | 1.7% |
| Value | Count | Frequency (%) |
| � | 7 |
| Distinct | 14 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 1 |
| Missing (%) | < 0.1% |
| Memory size | 332.4 KiB |
| debt_consolidation | |
|---|---|
| credit_card | |
| other | |
| home_improvement | |
| major_purchase | |
| Other values (9) |
Length
| Max length | 18 |
|---|---|
| Median length | 16 |
| Mean length | 13.69112496 |
| Min length | 3 |
Characters and Unicode
| Total characters | 582352 |
|---|---|
| Distinct characters | 22 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | credit_card |
|---|---|
| 2nd row | car |
| 3rd row | small_business |
| 4th row | other |
| 5th row | other |
| Value | Count | Frequency (%) |
| debt_consolidation | 19776 | |
| credit_card | 5477 | 12.9% |
| other | 4425 | 10.4% |
| home_improvement | 3199 | 7.5% |
| major_purchase | 2311 | 5.4% |
| small_business | 1992 | 4.7% |
| car | 1615 | 3.8% |
| wedding | 1004 | 2.4% |
| medical | 753 | 1.8% |
| moving | 629 | 1.5% |
| Other values (4) | 1354 | 3.2% |
| Value | Count | Frequency (%) |
| debt_consolidation | 19776 | |
| credit_card | 5477 | 12.9% |
| other | 4425 | 10.4% |
| home_improvement | 3199 | 7.5% |
| major_purchase | 2311 | 5.4% |
| small_business | 1992 | 4.7% |
| car | 1615 | 3.8% |
| wedding | 1004 | 2.4% |
| medical | 753 | 1.8% |
| moving | 629 | 1.5% |
| Other values (4) | 1354 | 3.2% |
Most occurring characters
| Value | Count | Frequency (%) |
| o | 74339 | |
| d | 53689 | |
| t | 53475 | |
| i | 53428 | |
| n | 47410 | |
| e | 46713 | 8.0% |
| c | 36231 | 6.2% |
| a | 35985 | 6.2% |
| _ | 32861 | 5.6% |
| s | 30481 | 5.2% |
| Other values (12) | 117740 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 549491 | |
| Connector Punctuation | 32861 | 5.6% |
Most frequent character per category
| Value | Count | Frequency (%) |
| o | 74339 | |
| d | 53689 | |
| t | 53475 | |
| i | 53428 | |
| n | 47410 | |
| e | 46713 | |
| c | 36231 | 6.6% |
| a | 35985 | 6.5% |
| s | 30481 | 5.5% |
| l | 25041 | 4.6% |
| Other values (11) | 92699 |
| Value | Count | Frequency (%) |
| _ | 32861 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 549491 | |
| Common | 32861 | 5.6% |
Most frequent character per script
| Value | Count | Frequency (%) |
| o | 74339 | |
| d | 53689 | |
| t | 53475 | |
| i | 53428 | |
| n | 47410 | |
| e | 46713 | |
| c | 36231 | 6.6% |
| a | 35985 | 6.5% |
| s | 30481 | 5.5% |
| l | 25041 | 4.6% |
| Other values (11) | 92699 |
| Value | Count | Frequency (%) |
| _ | 32861 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 582352 |
Most frequent character per block
| Value | Count | Frequency (%) |
| o | 74339 | |
| d | 53689 | |
| t | 53475 | |
| i | 53428 | |
| n | 47410 | |
| e | 46713 | 8.0% |
| c | 36231 | 6.2% |
| a | 35985 | 6.2% |
| _ | 32861 | 5.6% |
| s | 30481 | 5.2% |
| Other values (12) | 117740 |
| Distinct | 21264 |
|---|---|
| Distinct (%) | 50.0% |
| Missing | 14 |
| Missing (%) | < 0.1% |
| Memory size | 332.4 KiB |
| Debt Consolidation | 2259 |
|---|---|
| Debt Consolidation Loan | 1760 |
| Personal Loan | 708 |
| Consolidation | 547 |
| debt consolidation | 532 |
| Other values (21259) |
Length
| Max length | 80 |
|---|---|
| Median length | 16 |
| Mean length | 17.34558581 |
| Min length | 2 |
Characters and Unicode
| Total characters | 737569 |
|---|---|
| Distinct characters | 108 |
| Distinct categories | 15 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 2 ? |
Unique
| Unique | 19113 ? |
|---|---|
| Unique (%) | 44.9% |
Sample
| 1st row | Computer |
|---|---|
| 2nd row | bike |
| 3rd row | real estate business |
| 4th row | personel |
| 5th row | Personal |
| Value | Count | Frequency (%) |
| Debt Consolidation | 2259 | 5.3% |
| Debt Consolidation Loan | 1760 | 4.1% |
| Personal Loan | 708 | 1.7% |
| Consolidation | 547 | 1.3% |
| debt consolidation | 532 | 1.3% |
| Home Improvement | 373 | 0.9% |
| Credit Card Consolidation | 370 | 0.9% |
| Debt consolidation | 347 | 0.8% |
| Small Business Loan | 333 | 0.8% |
| Personal | 330 | 0.8% |
| Other values (21254) | 34963 |
| Value | Count | Frequency (%) |
| loan | 11503 | 10.2% |
| debt | 9723 | 8.6% |
| consolidation | 8994 | 7.9% |
| credit | 4952 | 4.4% |
| card | 3557 | 3.1% |
| personal | 2221 | 2.0% |
| home | 2025 | 1.8% |
| pay | 1473 | 1.3% |
| off | 1381 | 1.2% |
| to | 1286 | 1.1% |
| Other values (9389) | 66119 |
Most occurring characters
| Value | Count | Frequency (%) |
| 71985 | 9.8% | |
| o | 70249 | 9.5% |
| n | 59793 | 8.1% |
| e | 59393 | 8.1% |
| a | 53923 | 7.3% |
| i | 47247 | 6.4% |
| t | 45984 | 6.2% |
| d | 33017 | 4.5% |
| r | 31780 | 4.3% |
| s | 31001 | 4.2% |
| Other values (98) | 233197 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 563571 | |
| Uppercase Letter | 89179 | 12.1% |
| Space Separator | 71985 | 9.8% |
| Decimal Number | 6403 | 0.9% |
| Other Punctuation | 4910 | 0.7% |
| Dash Punctuation | 870 | 0.1% |
| Connector Punctuation | 220 | < 0.1% |
| Close Punctuation | 112 | < 0.1% |
| Currency Symbol | 104 | < 0.1% |
| Math Symbol | 103 | < 0.1% |
| Other values (5) | 112 | < 0.1% |
Most frequent character per category
| Value | Count | Frequency (%) |
| C | 19640 | |
| L | 10896 | |
| D | 9704 | |
| P | 6064 | 6.8% |
| R | 4044 | 4.5% |
| S | 3521 | 3.9% |
| M | 3502 | 3.9% |
| B | 3341 | 3.7% |
| H | 3187 | 3.6% |
| E | 3142 | 3.5% |
| Other values (18) | 22138 |
| Value | Count | Frequency (%) |
| o | 70249 | |
| n | 59793 | |
| e | 59393 | |
| a | 53923 | |
| i | 47247 | |
| t | 45984 | |
| d | 33017 | 5.9% |
| r | 31780 | 5.6% |
| s | 31001 | 5.5% |
| l | 28340 | 5.0% |
| Other values (18) | 102844 |
| Value | Count | Frequency (%) |
| ! | 1254 | |
| ' | 1068 | |
| . | 813 | |
| / | 589 | |
| , | 481 | 9.8% |
| & | 353 | 7.2% |
| % | 105 | 2.1% |
| : | 67 | 1.4% |
| " | 61 | 1.2% |
| ? | 27 | 0.5% |
| Other values (5) | 92 | 1.9% |
| Value | Count | Frequency (%) |
| 0 | 1822 | |
| 1 | 1761 | |
| 2 | 1188 | |
| 3 | 316 | 4.9% |
| 5 | 275 | 4.3% |
| 9 | 264 | 4.1% |
| 4 | 234 | 3.7% |
| 6 | 195 | 3.0% |
| 8 | 175 | 2.7% |
| 7 | 173 | 2.7% |
| Value | Count | Frequency (%) |
| | 4 | |
| | 4 | |
| | 4 | |
| 2 | ||
| | 2 | |
| | 1 | 5.3% |
| | 1 | 5.3% |
| 1 | 5.3% |
| Value | Count | Frequency (%) |
| + | 63 | |
| = | 19 | 18.4% |
| < | 9 | 8.7% |
| > | 8 | 7.8% |
| ~ | 3 | 2.9% |
| | | 1 | 1.0% |
| Value | Count | Frequency (%) |
| ^ | 1 | |
| ´ | 1 | |
| ` | 1 |
| Value | Count | Frequency (%) |
| ( | 84 | |
| [ | 3 | 3.4% |
| Value | Count | Frequency (%) |
| ) | 108 | |
| ] | 4 | 3.6% |
| Value | Count | Frequency (%) |
| 71985 |
| Value | Count | Frequency (%) |
| - | 870 |
| Value | Count | Frequency (%) |
| _ | 220 |
| Value | Count | Frequency (%) |
| $ | 104 |
| Value | Count | Frequency (%) |
| ³ | 1 |
| Value | Count | Frequency (%) |
| ¦ | 2 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 652750 | |
| Common | 84819 | 11.5% |
Most frequent character per script
| Value | Count | Frequency (%) |
| o | 70249 | 10.8% |
| n | 59793 | 9.2% |
| e | 59393 | 9.1% |
| a | 53923 | 8.3% |
| i | 47247 | 7.2% |
| t | 45984 | 7.0% |
| d | 33017 | 5.1% |
| r | 31780 | 4.9% |
| s | 31001 | 4.7% |
| l | 28340 | 4.3% |
| Other values (46) | 192023 |
| Value | Count | Frequency (%) |
| 71985 | ||
| 0 | 1822 | 2.1% |
| 1 | 1761 | 2.1% |
| ! | 1254 | 1.5% |
| 2 | 1188 | 1.4% |
| ' | 1068 | 1.3% |
| - | 870 | 1.0% |
| . | 813 | 1.0% |
| / | 589 | 0.7% |
| , | 481 | 0.6% |
| Other values (42) | 2988 | 3.5% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 737537 | |
| None | 32 | < 0.1% |
Most frequent character per block
| Value | Count | Frequency (%) |
| 71985 | 9.8% | |
| o | 70249 | 9.5% |
| n | 59793 | 8.1% |
| e | 59393 | 8.1% |
| a | 53923 | 7.3% |
| i | 47247 | 6.4% |
| t | 45984 | 6.2% |
| d | 33017 | 4.5% |
| r | 31780 | 4.3% |
| s | 31001 | 4.2% |
| Other values (84) | 233165 |
| Value | Count | Frequency (%) |
| â | 4 | |
| | 4 | |
| î | 4 | |
| | 4 | |
| | 4 | |
| Ã | 2 | |
| | 2 | |
| ¦ | 2 | |
| | 1 | 3.1% |
| | 1 | 3.1% |
| Other values (4) | 4 |
| Distinct | 837 |
|---|---|
| Distinct (%) | 2.0% |
| Missing | 1 |
| Missing (%) | < 0.1% |
| Memory size | 332.4 KiB |
| 100xx | 649 |
|---|---|
| 945xx | 559 |
| 606xx | 548 |
| 112xx | 538 |
| 070xx | 503 |
| Other values (832) |
Length
| Max length | 5 |
|---|---|
| Median length | 5 |
| Mean length | 5 |
| Min length | 5 |
Characters and Unicode
| Total characters | 212675 |
|---|---|
| Distinct characters | 11 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 54 ? |
|---|---|
| Unique (%) | 0.1% |
Sample
| 1st row | 860xx |
|---|---|
| 2nd row | 309xx |
| 3rd row | 606xx |
| 4th row | 917xx |
| 5th row | 972xx |
| Value | Count | Frequency (%) |
| 100xx | 649 | 1.5% |
| 945xx | 559 | 1.3% |
| 606xx | 548 | 1.3% |
| 112xx | 538 | 1.3% |
| 070xx | 503 | 1.2% |
| 900xx | 478 | 1.1% |
| 300xx | 436 | 1.0% |
| 021xx | 416 | 1.0% |
| 750xx | 392 | 0.9% |
| 926xx | 387 | 0.9% |
| Other values (827) | 37629 |
| Value | Count | Frequency (%) |
| 100xx | 649 | 1.5% |
| 945xx | 559 | 1.3% |
| 606xx | 548 | 1.3% |
| 112xx | 538 | 1.3% |
| 070xx | 503 | 1.2% |
| 900xx | 478 | 1.1% |
| 300xx | 436 | 1.0% |
| 021xx | 416 | 1.0% |
| 750xx | 392 | 0.9% |
| 926xx | 387 | 0.9% |
| Other values (827) | 37629 |
Most occurring characters
| Value | Count | Frequency (%) |
| x | 85070 | |
| 0 | 21264 | 10.0% |
| 1 | 16676 | 7.8% |
| 2 | 14431 | 6.8% |
| 9 | 13409 | 6.3% |
| 3 | 13348 | 6.3% |
| 7 | 10980 | 5.2% |
| 4 | 9793 | 4.6% |
| 5 | 9663 | 4.5% |
| 8 | 9322 | 4.4% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 127605 | |
| Lowercase Letter | 85070 |
Most frequent character per category
| Value | Count | Frequency (%) |
| 0 | 21264 | |
| 1 | 16676 | |
| 2 | 14431 | |
| 9 | 13409 | |
| 3 | 13348 | |
| 7 | 10980 | |
| 4 | 9793 | |
| 5 | 9663 | |
| 8 | 9322 | |
| 6 | 8719 |
| Value | Count | Frequency (%) |
| x | 85070 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 127605 | |
| Latin | 85070 |
Most frequent character per script
| Value | Count | Frequency (%) |
| 0 | 21264 | |
| 1 | 16676 | |
| 2 | 14431 | |
| 9 | 13409 | |
| 3 | 13348 | |
| 7 | 10980 | |
| 4 | 9793 | |
| 5 | 9663 | |
| 8 | 9322 | |
| 6 | 8719 |
| Value | Count | Frequency (%) |
| x | 85070 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 212675 |
Most frequent character per block
| Value | Count | Frequency (%) |
| x | 85070 | |
| 0 | 21264 | 10.0% |
| 1 | 16676 | 7.8% |
| 2 | 14431 | 6.8% |
| 9 | 13409 | 6.3% |
| 3 | 13348 | 6.3% |
| 7 | 10980 | 5.2% |
| 4 | 9793 | 4.6% |
| 5 | 9663 | 4.5% |
| 8 | 9322 | 4.4% |
| Distinct | 50 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 1 |
| Missing (%) | < 0.1% |
| Memory size | 332.4 KiB |
| CA | |
|---|---|
| NY | |
| FL | |
| TX | |
| NJ | 1988 |
| Other values (45) |
Length
| Max length | 2 |
|---|---|
| Median length | 2 |
| Mean length | 2 |
| Min length | 2 |
Characters and Unicode
| Total characters | 85070 |
|---|---|
| Distinct characters | 24 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | AZ |
|---|---|
| 2nd row | GA |
| 3rd row | IL |
| 4th row | CA |
| 5th row | OR |
| Value | Count | Frequency (%) |
| CA | 7429 | |
| NY | 4065 | 9.6% |
| FL | 3104 | 7.3% |
| TX | 2915 | 6.9% |
| NJ | 1988 | 4.7% |
| IL | 1672 | 3.9% |
| PA | 1651 | 3.9% |
| GA | 1503 | 3.5% |
| VA | 1487 | 3.5% |
| MA | 1438 | 3.4% |
| Other values (40) | 15283 |
| Value | Count | Frequency (%) |
| ca | 7429 | |
| ny | 4065 | 9.6% |
| fl | 3104 | 7.3% |
| tx | 2915 | 6.9% |
| nj | 1988 | 4.7% |
| il | 1672 | 3.9% |
| pa | 1651 | 3.9% |
| ga | 1503 | 3.5% |
| va | 1487 | 3.5% |
| ma | 1438 | 3.4% |
| Other values (40) | 15283 |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 16633 | |
| C | 10645 | |
| N | 8517 | |
| L | 5721 | 6.7% |
| M | 5106 | 6.0% |
| Y | 4511 | 5.3% |
| T | 4194 | 4.9% |
| O | 3736 | 4.4% |
| I | 3413 | 4.0% |
| F | 3104 | 3.6% |
| Other values (14) | 19490 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 85070 |
Most frequent character per category
| Value | Count | Frequency (%) |
| A | 16633 | |
| C | 10645 | |
| N | 8517 | |
| L | 5721 | 6.7% |
| M | 5106 | 6.0% |
| Y | 4511 | 5.3% |
| T | 4194 | 4.9% |
| O | 3736 | 4.4% |
| I | 3413 | 4.0% |
| F | 3104 | 3.6% |
| Other values (14) | 19490 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 85070 |
Most frequent character per script
| Value | Count | Frequency (%) |
| A | 16633 | |
| C | 10645 | |
| N | 8517 | |
| L | 5721 | 6.7% |
| M | 5106 | 6.0% |
| Y | 4511 | 5.3% |
| T | 4194 | 4.9% |
| O | 3736 | 4.4% |
| I | 3413 | 4.0% |
| F | 3104 | 3.6% |
| Other values (14) | 19490 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 85070 |
Most frequent character per block
| Value | Count | Frequency (%) |
| A | 16633 | |
| C | 10645 | |
| N | 8517 | |
| L | 5721 | 6.7% |
| M | 5106 | 6.0% |
| Y | 4511 | 5.3% |
| T | 4194 | 4.9% |
| O | 3736 | 4.4% |
| I | 3413 | 4.0% |
| F | 3104 | 3.6% |
| Other values (14) | 19490 |
dti
Real number (ℝ≥0)
| Distinct | 2894 |
|---|---|
| Distinct (%) | 6.8% |
| Missing | 1 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 13.37304314 |
|---|---|
| Minimum | 0 |
| Maximum | 29.99 |
| Zeros | 206 |
| Zeros (%) | 0.5% |
| Memory size | 332.4 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 2.1 |
| Q1 | 8.2 |
| median | 13.47 |
| Q3 | 18.68 |
| 95-th percentile | 23.92 |
| Maximum | 29.99 |
| Range | 29.99 |
| Interquartile range (IQR) | 10.48 |
Descriptive statistics
| Standard deviation | 6.726314902 |
|---|---|
| Coefficient of variation (CV) | 0.5029756377 |
| Kurtosis | -0.8517436241 |
| Mean | 13.37304314 |
| Median Absolute Deviation (MAD) | 5.24 |
| Skewness | -0.02992193534 |
| Sum | 568822.39 |
| Variance | 45.24331216 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 206 | 0.5% |
| 12 | 54 | 0.1% |
| 10 | 46 | 0.1% |
| 18 | 46 | 0.1% |
| 19.2 | 45 | 0.1% |
| 13.2 | 43 | 0.1% |
| 13.5 | 41 | 0.1% |
| 16.8 | 41 | 0.1% |
| 12.48 | 40 | 0.1% |
| 15 | 38 | 0.1% |
| Other values (2884) | 41935 |
| Value | Count | Frequency (%) |
| 0 | 206 | |
| 0.01 | 3 | < 0.1% |
| 0.02 | 5 | < 0.1% |
| 0.03 | 2 | < 0.1% |
| 0.04 | 3 | < 0.1% |
| Value | Count | Frequency (%) |
| 29.99 | 1 | < 0.1% |
| 29.96 | 1 | < 0.1% |
| 29.95 | 2 | |
| 29.93 | 3 | |
| 29.92 | 2 |
| Distinct | 12 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 30 |
| Missing (%) | 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.152449066 |
|---|---|
| Minimum | 0 |
| Maximum | 13 |
| Zeros | 37771 |
| Zeros (%) | 88.8% |
| Memory size | 332.4 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 1 |
| Maximum | 13 |
| Range | 13 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.512406485 |
|---|---|
| Coefficient of variation (CV) | 3.361165131 |
| Kurtosis | 51.07281075 |
| Mean | 0.152449066 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 5.433362395 |
| Sum | 6480 |
| Variance | 0.2625604059 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 37771 | |
| 1 | 3595 | 8.5% |
| 2 | 771 | 1.8% |
| 3 | 244 | 0.6% |
| 4 | 72 | 0.2% |
| 5 | 27 | 0.1% |
| 6 | 13 | < 0.1% |
| 7 | 6 | < 0.1% |
| 8 | 3 | < 0.1% |
| 11 | 2 | < 0.1% |
| Other values (2) | 2 | < 0.1% |
| (Missing) | 30 | 0.1% |
| Value | Count | Frequency (%) |
| 0 | 37771 | |
| 1 | 3595 | 8.5% |
| 2 | 771 | 1.8% |
| 3 | 244 | 0.6% |
| 4 | 72 | 0.2% |
| Value | Count | Frequency (%) |
| 13 | 1 | < 0.1% |
| 11 | 2 | < 0.1% |
| 9 | 1 | < 0.1% |
| 8 | 3 | |
| 7 | 6 |
| Distinct | 530 |
|---|---|
| Distinct (%) | 1.2% |
| Missing | 30 |
| Missing (%) | 0.1% |
| Memory size | 332.4 KiB |
| Oct-1999 | 393 |
|---|---|
| Nov-1998 | 390 |
| Oct-2000 | 370 |
| Dec-1998 | 366 |
| Dec-1997 | 348 |
| Other values (525) |
Length
| Max length | 8 |
|---|---|
| Median length | 8 |
| Mean length | 8 |
| Min length | 8 |
Characters and Unicode
| Total characters | 340048 |
|---|---|
| Distinct characters | 33 |
| Distinct categories | 4 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 35 ? |
|---|---|
| Unique (%) | 0.1% |
Sample
| 1st row | Jan-1985 |
|---|---|
| 2nd row | Apr-1999 |
| 3rd row | Nov-2001 |
| 4th row | Feb-1996 |
| 5th row | Jan-1996 |
| Value | Count | Frequency (%) |
| Oct-1999 | 393 | 0.9% |
| Nov-1998 | 390 | 0.9% |
| Oct-2000 | 370 | 0.9% |
| Dec-1998 | 366 | 0.9% |
| Dec-1997 | 348 | 0.8% |
| Nov-2000 | 340 | 0.8% |
| Nov-1999 | 337 | 0.8% |
| Oct-1998 | 334 | 0.8% |
| Sep-2000 | 325 | 0.8% |
| Nov-1997 | 319 | 0.7% |
| Other values (520) | 38984 |
| Value | Count | Frequency (%) |
| oct-1999 | 393 | 0.9% |
| nov-1998 | 390 | 0.9% |
| oct-2000 | 370 | 0.9% |
| dec-1998 | 366 | 0.9% |
| dec-1997 | 348 | 0.8% |
| nov-2000 | 340 | 0.8% |
| nov-1999 | 337 | 0.8% |
| oct-1998 | 334 | 0.8% |
| sep-2000 | 325 | 0.8% |
| nov-1997 | 319 | 0.8% |
| Other values (520) | 38984 |
Most occurring characters
| Value | Count | Frequency (%) |
| 9 | 51514 | |
| - | 42506 | 12.5% |
| 0 | 36660 | 10.8% |
| 1 | 30534 | 9.0% |
| 2 | 19450 | 5.7% |
| e | 11233 | 3.3% |
| J | 10093 | 3.0% |
| u | 9950 | 2.9% |
| a | 9771 | 2.9% |
| 8 | 9027 | 2.7% |
| Other values (23) | 109310 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 170024 | |
| Lowercase Letter | 85012 | |
| Uppercase Letter | 42506 | 12.5% |
| Dash Punctuation | 42506 | 12.5% |
Most frequent character per category
| Value | Count | Frequency (%) |
| e | 11233 | |
| u | 9950 | |
| a | 9771 | |
| c | 8713 | |
| n | 6821 | |
| p | 6799 | |
| r | 5951 | |
| t | 4396 | 5.2% |
| o | 4196 | 4.9% |
| v | 4196 | 4.9% |
| Other values (4) | 12986 |
| Value | Count | Frequency (%) |
| 9 | 51514 | |
| 0 | 36660 | |
| 1 | 30534 | |
| 2 | 19450 | 11.4% |
| 8 | 9027 | 5.3% |
| 7 | 5164 | 3.0% |
| 4 | 4572 | 2.7% |
| 6 | 4557 | 2.7% |
| 5 | 4519 | 2.7% |
| 3 | 4027 | 2.4% |
| Value | Count | Frequency (%) |
| J | 10093 | |
| A | 6490 | |
| M | 6098 | |
| O | 4396 | |
| D | 4317 | |
| N | 4196 | |
| S | 3839 | 9.0% |
| F | 3077 | 7.2% |
| Value | Count | Frequency (%) |
| - | 42506 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 212530 | |
| Latin | 127518 |
Most frequent character per script
| Value | Count | Frequency (%) |
| e | 11233 | 8.8% |
| J | 10093 | 7.9% |
| u | 9950 | 7.8% |
| a | 9771 | 7.7% |
| c | 8713 | 6.8% |
| n | 6821 | 5.3% |
| p | 6799 | 5.3% |
| A | 6490 | 5.1% |
| M | 6098 | 4.8% |
| r | 5951 | 4.7% |
| Other values (12) | 45599 |
| Value | Count | Frequency (%) |
| 9 | 51514 | |
| - | 42506 | |
| 0 | 36660 | |
| 1 | 30534 | |
| 2 | 19450 | 9.2% |
| 8 | 9027 | 4.2% |
| 7 | 5164 | 2.4% |
| 4 | 4572 | 2.2% |
| 6 | 4557 | 2.1% |
| 5 | 4519 | 2.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 340048 |
Most frequent character per block
| Value | Count | Frequency (%) |
| 9 | 51514 | |
| - | 42506 | 12.5% |
| 0 | 36660 | 10.8% |
| 1 | 30534 | 9.0% |
| 2 | 19450 | 5.7% |
| e | 11233 | 3.3% |
| J | 10093 | 3.0% |
| u | 9950 | 2.9% |
| a | 9771 | 2.9% |
| 8 | 9027 | 2.7% |
| Other values (23) | 109310 |
| Distinct | 44 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 1 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 713.052545 |
|---|---|
| Minimum | 610 |
| Maximum | 825 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 332.4 KiB |
Quantile statistics
| Minimum | 610 |
|---|---|
| 5-th percentile | 665 |
| Q1 | 685 |
| median | 710 |
| Q3 | 740 |
| 95-th percentile | 780 |
| Maximum | 825 |
| Range | 215 |
| Interquartile range (IQR) | 55 |
Descriptive statistics
| Standard deviation | 36.18843854 |
|---|---|
| Coefficient of variation (CV) | 0.05075143311 |
| Kurtosis | -0.4963339445 |
| Mean | 713.052545 |
| Median Absolute Deviation (MAD) | 25 |
| Skewness | 0.4648712594 |
| Sum | 30329690 |
| Variance | 1309.603084 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) |
| 685 | 2310 | 5.4% |
| 700 | 2267 | 5.3% |
| 680 | 2228 | 5.2% |
| 695 | 2202 | 5.2% |
| 690 | 2196 | 5.2% |
| 675 | 1994 | 4.7% |
| 705 | 1970 | 4.6% |
| 720 | 1949 | 4.6% |
| 725 | 1891 | 4.4% |
| 715 | 1891 | 4.4% |
| Other values (34) | 21637 |
| Value | Count | Frequency (%) |
| 610 | 2 | < 0.1% |
| 615 | 1 | < 0.1% |
| 620 | 1 | < 0.1% |
| 625 | 2 | < 0.1% |
| 630 | 6 |
| Value | Count | Frequency (%) |
| 825 | 3 | < 0.1% |
| 820 | 19 | < 0.1% |
| 815 | 28 | 0.1% |
| 810 | 125 | |
| 805 | 193 |
| Distinct | 44 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 1 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 717.052545 |
|---|---|
| Minimum | 614 |
| Maximum | 829 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 332.4 KiB |
Quantile statistics
| Minimum | 614 |
|---|---|
| 5-th percentile | 669 |
| Q1 | 689 |
| median | 714 |
| Q3 | 744 |
| 95-th percentile | 784 |
| Maximum | 829 |
| Range | 215 |
| Interquartile range (IQR) | 55 |
Descriptive statistics
| Standard deviation | 36.18843854 |
|---|---|
| Coefficient of variation (CV) | 0.05046832173 |
| Kurtosis | -0.4963339445 |
| Mean | 717.052545 |
| Median Absolute Deviation (MAD) | 25 |
| Skewness | 0.4648712594 |
| Sum | 30499830 |
| Variance | 1309.603084 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) |
| 689 | 2310 | 5.4% |
| 704 | 2267 | 5.3% |
| 684 | 2228 | 5.2% |
| 699 | 2202 | 5.2% |
| 694 | 2196 | 5.2% |
| 679 | 1994 | 4.7% |
| 709 | 1970 | 4.6% |
| 724 | 1949 | 4.6% |
| 719 | 1891 | 4.4% |
| 729 | 1891 | 4.4% |
| Other values (34) | 21637 |
| Value | Count | Frequency (%) |
| 614 | 2 | < 0.1% |
| 619 | 1 | < 0.1% |
| 624 | 1 | < 0.1% |
| 629 | 2 | < 0.1% |
| 634 | 6 |
| Value | Count | Frequency (%) |
| 829 | 3 | < 0.1% |
| 824 | 19 | < 0.1% |
| 819 | 28 | 0.1% |
| 814 | 125 | |
| 809 | 193 |
| Distinct | 28 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 30 |
| Missing (%) | 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.081423799 |
|---|---|
| Minimum | 0 |
| Maximum | 33 |
| Zeros | 19657 |
| Zeros (%) | 46.2% |
| Memory size | 332.4 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 1 |
| Q3 | 2 |
| 95-th percentile | 4 |
| Maximum | 33 |
| Range | 33 |
| Interquartile range (IQR) | 2 |
Descriptive statistics
| Standard deviation | 1.527454835 |
|---|---|
| Coefficient of variation (CV) | 1.412447957 |
| Kurtosis | 30.96220493 |
| Mean | 1.081423799 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 3.453516564 |
| Sum | 45967 |
| Variance | 2.333118274 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 19657 | |
| 1 | 11247 | |
| 2 | 5987 | 14.1% |
| 3 | 3182 | 7.5% |
| 4 | 1056 | 2.5% |
| 5 | 596 | 1.4% |
| 6 | 339 | 0.8% |
| 7 | 182 | 0.4% |
| 8 | 115 | 0.3% |
| 9 | 50 | 0.1% |
| Other values (18) | 95 | 0.2% |
| (Missing) | 30 | 0.1% |
| Value | Count | Frequency (%) |
| 0 | 19657 | |
| 1 | 11247 | |
| 2 | 5987 | 14.1% |
| 3 | 3182 | 7.5% |
| 4 | 1056 | 2.5% |
| Value | Count | Frequency (%) |
| 33 | 1 | |
| 32 | 1 | |
| 31 | 1 | |
| 28 | 1 | |
| 27 | 1 |
| Distinct | 95 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 12.85005642 |
|---|---|
| Minimum | 0 |
| Maximum | 120 |
| Zeros | 27748 |
| Zeros (%) | 65.2% |
| Memory size | 332.4 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 21 |
| 95-th percentile | 64 |
| Maximum | 120 |
| Range | 120 |
| Interquartile range (IQR) | 21 |
Descriptive statistics
| Standard deviation | 21.66292728 |
|---|---|
| Coefficient of variation (CV) | 1.685823514 |
| Kurtosis | 1.356389979 |
| Mean | 12.85005642 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 1.590947228 |
| Sum | 546590 |
| Variance | 469.2824182 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 27748 | |
| 30 | 270 | 0.6% |
| 23 | 266 | 0.6% |
| 19 | 266 | 0.6% |
| 15 | 263 | 0.6% |
| 24 | 262 | 0.6% |
| 18 | 252 | 0.6% |
| 38 | 251 | 0.6% |
| 20 | 249 | 0.6% |
| 22 | 248 | 0.6% |
| Other values (85) | 12461 |
| Value | Count | Frequency (%) |
| 0 | 27748 | |
| 1 | 33 | 0.1% |
| 2 | 115 | 0.3% |
| 3 | 157 | 0.4% |
| 4 | 164 | 0.4% |
| Value | Count | Frequency (%) |
| 120 | 1 | |
| 115 | 1 | |
| 107 | 1 | |
| 106 | 1 | |
| 103 | 2 |
| Distinct | 113 |
|---|---|
| Distinct (%) | 3.1% |
| Missing | 38885 |
| Missing (%) | 91.4% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 59.17556834 |
|---|---|
| Minimum | 0 |
| Maximum | 129 |
| Zeros | 1275 |
| Zeros (%) | 3.0% |
| Memory size | 332.4 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 85 |
| Q3 | 101 |
| 95-th percentile | 115 |
| Maximum | 129 |
| Range | 129 |
| Interquartile range (IQR) | 101 |
Descriptive statistics
| Standard deviation | 47.1453958 |
|---|---|
| Coefficient of variation (CV) | 0.7967037263 |
| Kurtosis | -1.694391517 |
| Mean | 59.17556834 |
| Median Absolute Deviation (MAD) | 28 |
| Skewness | -0.2834457395 |
| Sum | 216050 |
| Variance | 2222.688345 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 1275 | 3.0% |
| 89 | 70 | 0.2% |
| 113 | 68 | 0.2% |
| 104 | 66 | 0.2% |
| 86 | 62 | 0.1% |
| 87 | 62 | 0.1% |
| 94 | 61 | 0.1% |
| 100 | 60 | 0.1% |
| 111 | 60 | 0.1% |
| 88 | 59 | 0.1% |
| Other values (103) | 1808 | 4.3% |
| (Missing) | 38885 |
| Value | Count | Frequency (%) |
| 0 | 1275 | |
| 5 | 1 | < 0.1% |
| 6 | 1 | < 0.1% |
| 7 | 1 | < 0.1% |
| 11 | 2 | < 0.1% |
| Value | Count | Frequency (%) |
| 129 | 1 | < 0.1% |
| 120 | 1 | < 0.1% |
| 119 | 10 | < 0.1% |
| 118 | 40 | |
| 117 | 50 |
open_acc
Real number (ℝ≥0)
| Distinct | 44 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 30 |
| Missing (%) | 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 9.343951442 |
|---|---|
| Minimum | 1 |
| Maximum | 47 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 332.4 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 3 |
| Q1 | 6 |
| median | 9 |
| Q3 | 12 |
| 95-th percentile | 18 |
| Maximum | 47 |
| Range | 46 |
| Interquartile range (IQR) | 6 |
Descriptive statistics
| Standard deviation | 4.496273876 |
|---|---|
| Coefficient of variation (CV) | 0.4811961945 |
| Kurtosis | 1.935047655 |
| Mean | 9.343951442 |
| Median Absolute Deviation (MAD) | 3 |
| Skewness | 1.042024818 |
| Sum | 397174 |
| Variance | 20.21647877 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) |
| 7 | 4252 | |
| 8 | 4176 | |
| 6 | 4172 | |
| 9 | 3922 | |
| 10 | 3386 | 8.0% |
| 5 | 3368 | 7.9% |
| 11 | 2944 | 6.9% |
| 4 | 2508 | 5.9% |
| 12 | 2398 | 5.6% |
| 13 | 2060 | 4.8% |
| Other values (34) | 9320 |
| Value | Count | Frequency (%) |
| 1 | 39 | 0.1% |
| 2 | 692 | 1.6% |
| 3 | 1608 | |
| 4 | 2508 | |
| 5 | 3368 |
| Value | Count | Frequency (%) |
| 47 | 1 | |
| 46 | 1 | |
| 44 | 1 | |
| 42 | 1 | |
| 41 | 1 |
| Distinct | 6 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 30 |
| Missing (%) | 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.05815649555 |
|---|---|
| Minimum | 0 |
| Maximum | 5 |
| Zeros | 40130 |
| Zeros (%) | 94.3% |
| Memory size | 332.4 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 1 |
| Maximum | 5 |
| Range | 5 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.2457131407 |
|---|---|
| Coefficient of variation (CV) | 4.225033478 |
| Kurtosis | 26.83502204 |
| Mean | 0.05815649555 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 4.605515995 |
| Sum | 2472 |
| Variance | 0.06037494749 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 40130 | |
| 1 | 2298 | 5.4% |
| 2 | 64 | 0.2% |
| 3 | 11 | < 0.1% |
| 4 | 2 | < 0.1% |
| 5 | 1 | < 0.1% |
| (Missing) | 30 | 0.1% |
| Value | Count | Frequency (%) |
| 0 | 40130 | |
| 1 | 2298 | 5.4% |
| 2 | 64 | 0.2% |
| 3 | 11 | < 0.1% |
| 4 | 2 | < 0.1% |
| Value | Count | Frequency (%) |
| 5 | 1 | < 0.1% |
| 4 | 2 | < 0.1% |
| 3 | 11 | < 0.1% |
| 2 | 64 | 0.2% |
| 1 | 2298 |
| Distinct | 22709 |
|---|---|
| Distinct (%) | 53.4% |
| Missing | 1 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 14297.86091 |
|---|---|
| Minimum | 0 |
| Maximum | 1207359 |
| Zeros | 1119 |
| Zeros (%) | 2.6% |
| Memory size | 332.4 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 295.4 |
| Q1 | 3635 |
| median | 8821 |
| Q3 | 17251 |
| 95-th percentile | 44543.9 |
| Maximum | 1207359 |
| Range | 1207359 |
| Interquartile range (IQR) | 13616 |
Descriptive statistics
| Standard deviation | 22018.44101 |
|---|---|
| Coefficient of variation (CV) | 1.53998148 |
| Kurtosis | 346.2882917 |
| Mean | 14297.86091 |
| Median Absolute Deviation (MAD) | 6092 |
| Skewness | 11.01229081 |
| Sum | 608159514 |
| Variance | 484811744.5 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 1119 | 2.6% |
| 255 | 14 | < 0.1% |
| 298 | 14 | < 0.1% |
| 1 | 13 | < 0.1% |
| 682 | 12 | < 0.1% |
| 52 | 10 | < 0.1% |
| 6 | 10 | < 0.1% |
| 400 | 10 | < 0.1% |
| 39 | 10 | < 0.1% |
| 1763 | 9 | < 0.1% |
| Other values (22699) | 41314 |
| Value | Count | Frequency (%) |
| 0 | 1119 | |
| 1 | 13 | < 0.1% |
| 2 | 6 | < 0.1% |
| 3 | 7 | < 0.1% |
| 4 | 3 | < 0.1% |
| Value | Count | Frequency (%) |
| 1207359 | 1 | |
| 952013 | 1 | |
| 602519 | 1 | |
| 508961 | 1 | |
| 487589 | 1 |
| Distinct | 1119 |
|---|---|
| Distinct (%) | 2.6% |
| Missing | 91 |
| Missing (%) | 0.2% |
| Memory size | 332.4 KiB |
| 0% | 1070 |
|---|---|
| 40.7% | 65 |
| 0.2% | 64 |
| 63% | 63 |
| 66.6% | 62 |
| Other values (1114) |
Length
| Max length | 6 |
|---|---|
| Median length | 5 |
| Mean length | 4.646530805 |
| Min length | 2 |
Characters and Unicode
| Total characters | 197222 |
|---|---|
| Distinct characters | 12 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 115 ? |
|---|---|
| Unique (%) | 0.3% |
Sample
| 1st row | 83.7% |
|---|---|
| 2nd row | 9.4% |
| 3rd row | 98.5% |
| 4th row | 21% |
| 5th row | 53.9% |
| Value | Count | Frequency (%) |
| 0% | 1070 | 2.5% |
| 40.7% | 65 | 0.2% |
| 0.2% | 64 | 0.2% |
| 63% | 63 | 0.1% |
| 66.6% | 62 | 0.1% |
| 0.1% | 61 | 0.1% |
| 70.4% | 61 | 0.1% |
| 37.6% | 60 | 0.1% |
| 64.6% | 60 | 0.1% |
| 35.3% | 59 | 0.1% |
| Other values (1109) | 40820 | |
| (Missing) | 91 | 0.2% |
| Value | Count | Frequency (%) |
| 0 | 1070 | 2.5% |
| 40.7 | 65 | 0.2% |
| 0.2 | 64 | 0.2% |
| 63 | 63 | 0.1% |
| 66.6 | 62 | 0.1% |
| 0.1 | 61 | 0.1% |
| 70.4 | 61 | 0.1% |
| 64.6 | 60 | 0.1% |
| 37.6 | 60 | 0.1% |
| 66.7 | 59 | 0.1% |
| Other values (1109) | 40820 |
Most occurring characters
| Value | Count | Frequency (%) |
| % | 42445 | |
| . | 37253 | |
| 4 | 12918 | 6.5% |
| 5 | 12907 | 6.5% |
| 6 | 12837 | 6.5% |
| 7 | 12831 | 6.5% |
| 3 | 12671 | 6.4% |
| 2 | 12329 | 6.3% |
| 8 | 12268 | 6.2% |
| 1 | 11830 | 6.0% |
| Other values (2) | 16933 | 8.6% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 117524 | |
| Other Punctuation | 79698 |
Most frequent character per category
| Value | Count | Frequency (%) |
| 4 | 12918 | |
| 5 | 12907 | |
| 6 | 12837 | |
| 7 | 12831 | |
| 3 | 12671 | |
| 2 | 12329 | |
| 8 | 12268 | |
| 1 | 11830 | |
| 9 | 11612 | |
| 0 | 5321 |
| Value | Count | Frequency (%) |
| % | 42445 | |
| . | 37253 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 197222 |
Most frequent character per script
| Value | Count | Frequency (%) |
| % | 42445 | |
| . | 37253 | |
| 4 | 12918 | 6.5% |
| 5 | 12907 | 6.5% |
| 6 | 12837 | 6.5% |
| 7 | 12831 | 6.5% |
| 3 | 12671 | 6.4% |
| 2 | 12329 | 6.3% |
| 8 | 12268 | 6.2% |
| 1 | 11830 | 6.0% |
| Other values (2) | 16933 | 8.6% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 197222 |
Most frequent character per block
| Value | Count | Frequency (%) |
| % | 42445 | |
| . | 37253 | |
| 4 | 12918 | 6.5% |
| 5 | 12907 | 6.5% |
| 6 | 12837 | 6.5% |
| 7 | 12831 | 6.5% |
| 3 | 12671 | 6.4% |
| 2 | 12329 | 6.3% |
| 8 | 12268 | 6.2% |
| 1 | 11830 | 6.0% |
| Other values (2) | 16933 | 8.6% |
total_acc
Real number (ℝ≥0)
| Distinct | 83 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 30 |
| Missing (%) | 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 22.12440597 |
|---|---|
| Minimum | 1 |
| Maximum | 90 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 332.4 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 6 |
| Q1 | 13 |
| median | 20 |
| Q3 | 29 |
| 95-th percentile | 44 |
| Maximum | 90 |
| Range | 89 |
| Interquartile range (IQR) | 16 |
Descriptive statistics
| Standard deviation | 11.59281134 |
|---|---|
| Coefficient of variation (CV) | 0.5239829424 |
| Kurtosis | 0.6588546244 |
| Mean | 22.12440597 |
| Median Absolute Deviation (MAD) | 8 |
| Skewness | 0.8223755587 |
| Sum | 940420 |
| Variance | 134.3932747 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) |
| 15 | 1552 | 3.6% |
| 16 | 1547 | 3.6% |
| 17 | 1543 | 3.6% |
| 14 | 1531 | 3.6% |
| 20 | 1504 | 3.5% |
| 18 | 1493 | 3.5% |
| 21 | 1483 | 3.5% |
| 13 | 1480 | 3.5% |
| 12 | 1416 | 3.3% |
| 19 | 1404 | 3.3% |
| Other values (73) | 27553 |
| Value | Count | Frequency (%) |
| 1 | 21 | < 0.1% |
| 2 | 41 | 0.1% |
| 3 | 238 | 0.6% |
| 4 | 486 | |
| 5 | 622 |
| Value | Count | Frequency (%) |
| 90 | 1 | |
| 87 | 1 | |
| 81 | 1 | |
| 80 | 1 | |
| 79 | 2 |
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 1 |
| Missing (%) | < 0.1% |
| Memory size | 83.2 KiB |
| False | |
|---|---|
| (Missing) | 1 |
| Value | Count | Frequency (%) |
| False | 42535 | |
| (Missing) | 1 | < 0.1% |
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 1 |
| Missing (%) | < 0.1% |
| Memory size | 332.4 KiB |
| 0.0 |
|---|
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Characters and Unicode
| Total characters | 127605 |
|---|---|
| Distinct characters | 2 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0.0 |
|---|---|
| 2nd row | 0.0 |
| 3rd row | 0.0 |
| 4th row | 0.0 |
| 5th row | 0.0 |
| Value | Count | Frequency (%) |
| 0.0 | 42535 | |
| (Missing) | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 0.0 | 42535 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 85070 | |
| . | 42535 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 85070 | |
| Other Punctuation | 42535 |
Most frequent character per category
| Value | Count | Frequency (%) |
| 0 | 85070 |
| Value | Count | Frequency (%) |
| . | 42535 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 127605 |
Most frequent character per script
| Value | Count | Frequency (%) |
| 0 | 85070 | |
| . | 42535 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 127605 |
Most frequent character per block
| Value | Count | Frequency (%) |
| 0 | 85070 | |
| . | 42535 |
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 1 |
| Missing (%) | < 0.1% |
| Memory size | 332.4 KiB |
| 0.0 |
|---|
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Characters and Unicode
| Total characters | 127605 |
|---|---|
| Distinct characters | 2 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0.0 |
|---|---|
| 2nd row | 0.0 |
| 3rd row | 0.0 |
| 4th row | 0.0 |
| 5th row | 0.0 |
| Value | Count | Frequency (%) |
| 0.0 | 42535 | |
| (Missing) | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 0.0 | 42535 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 85070 | |
| . | 42535 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 85070 | |
| Other Punctuation | 42535 |
Most frequent character per category
| Value | Count | Frequency (%) |
| 0 | 85070 |
| Value | Count | Frequency (%) |
| . | 42535 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 127605 |
Most frequent character per script
| Value | Count | Frequency (%) |
| 0 | 85070 | |
| . | 42535 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 127605 |
Most frequent character per block
| Value | Count | Frequency (%) |
| 0 | 85070 | |
| . | 42535 |
| Distinct | 42366 |
|---|---|
| Distinct (%) | 99.6% |
| Missing | 1 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 12020.18964 |
|---|---|
| Minimum | 0 |
| Maximum | 58886.47343 |
| Zeros | 19 |
| Zeros (%) | < 0.1% |
| Memory size | 332.4 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1806.248222 |
| Q1 | 5465.685189 |
| median | 9682.251696 |
| Q3 | 16427.85007 |
| 95-th percentile | 30211.27777 |
| Maximum | 58886.47343 |
| Range | 58886.47343 |
| Interquartile range (IQR) | 10962.16488 |
Descriptive statistics
| Standard deviation | 9094.685888 |
|---|---|
| Coefficient of variation (CV) | 0.7566175041 |
| Kurtosis | 2.175341593 |
| Mean | 12020.18964 |
| Median Absolute Deviation (MAD) | 4994.958304 |
| Skewness | 1.379195192 |
| Sum | 511278766.5 |
| Variance | 82713311.4 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 19 | < 0.1% |
| 12029.45 | 6 | < 0.1% |
| 90 | 6 | < 0.1% |
| 180 | 4 | < 0.1% |
| 45 | 3 | < 0.1% |
| 11804.68932 | 3 | < 0.1% |
| 11553.89594 | 3 | < 0.1% |
| 26687.23 | 3 | < 0.1% |
| 11437.69145 | 3 | < 0.1% |
| 11955.39921 | 3 | < 0.1% |
| Other values (42356) | 42482 |
| Value | Count | Frequency (%) |
| 0 | 19 | |
| 0.75 | 1 | < 0.1% |
| 0.8 | 1 | < 0.1% |
| 33.97 | 1 | < 0.1% |
| 35.9 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 58886.47343 | 1 | |
| 58563.67993 | 1 | |
| 58480.13992 | 1 | |
| 58133.3199 | 1 | |
| 58090.95207 | 1 |
| Distinct | 40102 |
|---|---|
| Distinct (%) | 94.3% |
| Missing | 1 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 11312.72938 |
|---|---|
| Minimum | 0 |
| Maximum | 58563.68 |
| Zeros | 297 |
| Zeros (%) | 0.7% |
| Memory size | 332.4 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1161.239 |
| Q1 | 4793.115 |
| median | 8956.08 |
| Q3 | 15543.875 |
| 95-th percentile | 29629.481 |
| Maximum | 58563.68 |
| Range | 58563.68 |
| Interquartile range (IQR) | 10750.76 |
Descriptive statistics
| Standard deviation | 9038.506549 |
|---|---|
| Coefficient of variation (CV) | 0.7989678042 |
| Kurtosis | 2.220726227 |
| Mean | 11312.72938 |
| Median Absolute Deviation (MAD) | 4981.82 |
| Skewness | 1.393032244 |
| Sum | 481186944 |
| Variance | 81694600.64 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 297 | 0.7% |
| 6514.52 | 16 | < 0.1% |
| 13148.14 | 14 | < 0.1% |
| 5478.39 | 14 | < 0.1% |
| 10956.78 | 12 | < 0.1% |
| 6717.95 | 12 | < 0.1% |
| 11196.57 | 12 | < 0.1% |
| 7328.92 | 11 | < 0.1% |
| 5557.03 | 11 | < 0.1% |
| 13517.36 | 11 | < 0.1% |
| Other values (40092) | 42125 |
| Value | Count | Frequency (%) |
| 0 | 297 | |
| 0.51 | 1 | < 0.1% |
| 0.54 | 1 | < 0.1% |
| 0.75 | 1 | < 0.1% |
| 0.8 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 58563.68 | 1 | |
| 58514.93 | 1 | |
| 58438.37 | 1 | |
| 58056.4 | 1 | |
| 57967.53 | 1 |
| Distinct | 7691 |
|---|---|
| Distinct (%) | 18.1% |
| Missing | 1 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 9675.675936 |
|---|---|
| Minimum | 0 |
| Maximum | 35000.02 |
| Zeros | 86 |
| Zeros (%) | 0.2% |
| Memory size | 332.4 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1203.661 |
| Q1 | 4400 |
| median | 8000 |
| Q3 | 13499.995 |
| 95-th percentile | 24999.99 |
| Maximum | 35000.02 |
| Range | 35000.02 |
| Interquartile range (IQR) | 9099.995 |
Descriptive statistics
| Standard deviation | 7105.750304 |
|---|---|
| Coefficient of variation (CV) | 0.7343931681 |
| Kurtosis | 1.143927598 |
| Mean | 9675.675936 |
| Median Absolute Deviation (MAD) | 4000 |
| Skewness | 1.136695315 |
| Sum | 411554875.9 |
| Variance | 50491687.38 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) |
| 10000 | 2432 | 5.7% |
| 12000 | 1958 | 4.6% |
| 5000 | 1861 | 4.4% |
| 6000 | 1752 | 4.1% |
| 15000 | 1529 | 3.6% |
| 8000 | 1414 | 3.3% |
| 20000 | 1200 | 2.8% |
| 4000 | 1046 | 2.5% |
| 3000 | 975 | 2.3% |
| 7000 | 901 | 2.1% |
| Other values (7681) | 27467 |
| Value | Count | Frequency (%) |
| 0 | 86 | |
| 21.21 | 1 | < 0.1% |
| 21.93 | 1 | < 0.1% |
| 22.24 | 1 | < 0.1% |
| 22.5 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 35000.02 | 2 | < 0.1% |
| 35000.01 | 1 | < 0.1% |
| 35000 | 418 | |
| 34999.99 | 7 | < 0.1% |
| 34999.98 | 1 | < 0.1% |
total_rec_int
Real number (ℝ≥0)
| Distinct | 37462 |
|---|---|
| Distinct (%) | 88.1% |
| Missing | 1 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2239.981444 |
|---|---|
| Minimum | 0 |
| Maximum | 23886.47 |
| Zeros | 83 |
| Zeros (%) | 0.2% |
| Memory size | 332.4 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 183.961 |
| Q1 | 657.1 |
| median | 1339.16 |
| Q3 | 2803.09 |
| 95-th percentile | 7463.76 |
| Maximum | 23886.47 |
| Range | 23886.47 |
| Interquartile range (IQR) | 2145.99 |
Descriptive statistics
| Standard deviation | 2585.057393 |
|---|---|
| Coefficient of variation (CV) | 1.154053039 |
| Kurtosis | 10.0705644 |
| Mean | 2239.981444 |
| Median Absolute Deviation (MAD) | 858.74 |
| Skewness | 2.70883429 |
| Sum | 95277610.71 |
| Variance | 6682521.725 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 83 | 0.2% |
| 1196.57 | 26 | 0.1% |
| 514.52 | 19 | < 0.1% |
| 1148.14 | 17 | < 0.1% |
| 956.78 | 17 | < 0.1% |
| 717.95 | 17 | < 0.1% |
| 1784.23 | 17 | < 0.1% |
| 478.39 | 16 | < 0.1% |
| 1907.35 | 14 | < 0.1% |
| 632.21 | 13 | < 0.1% |
| Other values (37452) | 42296 |
| Value | Count | Frequency (%) |
| 0 | 83 | |
| 3.54 | 1 | < 0.1% |
| 6.22 | 1 | < 0.1% |
| 6.27 | 1 | < 0.1% |
| 7.19 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 23886.47 | 1 | |
| 23563.68 | 1 | |
| 23480.14 | 1 | |
| 23090.95 | 1 | |
| 23084.93 | 1 |
| Distinct | 2299 |
|---|---|
| Distinct (%) | 5.4% |
| Missing | 1 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.516889594 |
|---|---|
| Minimum | 0 |
| Maximum | 209 |
| Zeros | 40145 |
| Zeros (%) | 94.4% |
| Memory size | 332.4 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 14.97978247 |
| Maximum | 209 |
| Range | 209 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 7.830063955 |
|---|---|
| Coefficient of variation (CV) | 5.161920806 |
| Kurtosis | 101.1595044 |
| Mean | 1.516889594 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 8.337377936 |
| Sum | 64520.89888 |
| Variance | 61.30990155 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 40145 | |
| 15 | 69 | 0.2% |
| 30 | 8 | < 0.1% |
| 45 | 3 | < 0.1% |
| 15 | 2 | < 0.1% |
| 60 | 2 | < 0.1% |
| 17.7 | 2 | < 0.1% |
| 45 | 2 | < 0.1% |
| 15.00000001 | 2 | < 0.1% |
| 15 | 2 | < 0.1% |
| Other values (2289) | 2298 | 5.4% |
| Value | Count | Frequency (%) |
| 0 | 40145 | |
| 0.01 | 1 | < 0.1% |
| 0.0607997508 | 1 | < 0.1% |
| 0.0737871041 | 1 | < 0.1% |
| 0.1017045619 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 209 | 1 | |
| 180.2 | 1 | |
| 170.7600004 | 1 | |
| 166.4297107 | 1 | |
| 165.69 | 1 |
| Distinct | 5058 |
|---|---|
| Distinct (%) | 11.9% |
| Missing | 1 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 103.0154671 |
|---|---|
| Minimum | 0 |
| Maximum | 29623.35 |
| Zeros | 36176 |
| Zeros (%) | 85.0% |
| Memory size | 332.4 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 392.912 |
| Maximum | 29623.35 |
| Range | 29623.35 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 735.7990861 |
|---|---|
| Coefficient of variation (CV) | 7.142607871 |
| Kurtosis | 386.5922346 |
| Mean | 103.0154671 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 16.57335707 |
| Sum | 4381762.893 |
| Variance | 541400.2951 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 36176 | |
| 0.3 | 14 | < 0.1% |
| 1.8 | 11 | < 0.1% |
| 0.96 | 10 | < 0.1% |
| 1.2 | 10 | < 0.1% |
| 0.26 | 9 | < 0.1% |
| 0.9 | 9 | < 0.1% |
| 1.76 | 9 | < 0.1% |
| 6.3 | 9 | < 0.1% |
| 4.2 | 9 | < 0.1% |
| Other values (5048) | 6269 | 14.7% |
| Value | Count | Frequency (%) |
| 0 | 36176 | |
| 0.01 | 7 | < 0.1% |
| 0.02 | 3 | < 0.1% |
| 0.03 | 4 | < 0.1% |
| 0.04 | 6 | < 0.1% |
| Value | Count | Frequency (%) |
| 29623.35 | 1 | |
| 27750 | 1 | |
| 27009.47 | 1 | |
| 22943.37 | 1 | |
| 21811.73 | 1 |
| Distinct | 2897 |
|---|---|
| Distinct (%) | 6.8% |
| Missing | 1 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 14.38784299 |
|---|---|
| Minimum | 0 |
| Maximum | 7002.19 |
| Zeros | 38207 |
| Zeros (%) | 89.8% |
| Memory size | 332.4 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 5.76 |
| Maximum | 7002.19 |
| Range | 7002.19 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 162.1778368 |
|---|---|
| Coefficient of variation (CV) | 11.2718659 |
| Kurtosis | 647.9221659 |
| Mean | 14.38784299 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 22.41007601 |
| Sum | 611986.9015 |
| Variance | 26301.65075 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 38207 | |
| 2 | 15 | < 0.1% |
| 1.2 | 11 | < 0.1% |
| 1.6 | 10 | < 0.1% |
| 1.21 | 9 | < 0.1% |
| 1.44 | 9 | < 0.1% |
| 1.8 | 9 | < 0.1% |
| 2.02 | 9 | < 0.1% |
| 1.55 | 9 | < 0.1% |
| 3.23 | 9 | < 0.1% |
| Other values (2887) | 4238 | 10.0% |
| Value | Count | Frequency (%) |
| 0 | 38207 | |
| 0.0449999999 | 1 | < 0.1% |
| 0.063 | 1 | < 0.1% |
| 0.0745000012 | 1 | < 0.1% |
| 0.1181 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 7002.19 | 1 | |
| 6972.59 | 1 | |
| 6543.04 | 1 | |
| 5774.8 | 1 | |
| 5602.72 | 1 |
| Distinct | 112 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 84 |
| Missing (%) | 0.2% |
| Memory size | 332.4 KiB |
| Mar-2013 | 1070 |
|---|---|
| Dec-2014 | 949 |
| May-2013 | 943 |
| Feb-2013 | 906 |
| Mar-2012 | 893 |
| Other values (107) |
Length
| Max length | 8 |
|---|---|
| Median length | 8 |
| Mean length | 8 |
| Min length | 8 |
Characters and Unicode
| Total characters | 339616 |
|---|---|
| Distinct characters | 33 |
| Distinct categories | 4 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | Jan-2015 |
|---|---|
| 2nd row | Apr-2013 |
| 3rd row | Jun-2014 |
| 4th row | Jan-2015 |
| 5th row | Jan-2017 |
| Value | Count | Frequency (%) |
| Mar-2013 | 1070 | 2.5% |
| Dec-2014 | 949 | 2.2% |
| May-2013 | 943 | 2.2% |
| Feb-2013 | 906 | 2.1% |
| Mar-2012 | 893 | 2.1% |
| Apr-2013 | 890 | 2.1% |
| Aug-2012 | 868 | 2.0% |
| Oct-2012 | 853 | 2.0% |
| Jan-2014 | 845 | 2.0% |
| Aug-2014 | 836 | 2.0% |
| Other values (102) | 33399 |
| Value | Count | Frequency (%) |
| mar-2013 | 1070 | 2.5% |
| dec-2014 | 949 | 2.2% |
| may-2013 | 943 | 2.2% |
| feb-2013 | 906 | 2.1% |
| mar-2012 | 893 | 2.1% |
| apr-2013 | 890 | 2.1% |
| aug-2012 | 868 | 2.0% |
| oct-2012 | 853 | 2.0% |
| jan-2014 | 845 | 2.0% |
| aug-2014 | 836 | 2.0% |
| Other values (102) | 33399 |
Most occurring characters
| Value | Count | Frequency (%) |
| 2 | 51803 | |
| 1 | 47025 | |
| 0 | 46047 | |
| - | 42452 | |
| e | 10783 | 3.2% |
| a | 10775 | 3.2% |
| u | 10502 | 3.1% |
| J | 10186 | 3.0% |
| 3 | 9811 | 2.9% |
| 4 | 9322 | 2.7% |
| Other values (23) | 90910 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 169808 | |
| Lowercase Letter | 84904 | |
| Uppercase Letter | 42452 | 12.5% |
| Dash Punctuation | 42452 | 12.5% |
Most frequent character per category
| Value | Count | Frequency (%) |
| e | 10783 | |
| a | 10775 | |
| u | 10502 | |
| c | 7564 | |
| r | 7494 | |
| p | 6820 | |
| n | 6573 | |
| t | 3656 | 4.3% |
| l | 3613 | 4.3% |
| g | 3593 | 4.2% |
| Other values (4) | 13531 |
| Value | Count | Frequency (%) |
| 2 | 51803 | |
| 1 | 47025 | |
| 0 | 46047 | |
| 3 | 9811 | 5.8% |
| 4 | 9322 | 5.5% |
| 5 | 2511 | 1.5% |
| 6 | 2083 | 1.2% |
| 9 | 838 | 0.5% |
| 8 | 335 | 0.2% |
| 7 | 33 | < 0.1% |
| Value | Count | Frequency (%) |
| J | 10186 | |
| M | 7498 | |
| A | 7024 | |
| D | 3908 | 9.2% |
| O | 3656 | 8.6% |
| F | 3486 | 8.2% |
| S | 3389 | 8.0% |
| N | 3305 | 7.8% |
| Value | Count | Frequency (%) |
| - | 42452 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 212260 | |
| Latin | 127356 |
Most frequent character per script
| Value | Count | Frequency (%) |
| e | 10783 | 8.5% |
| a | 10775 | 8.5% |
| u | 10502 | 8.2% |
| J | 10186 | 8.0% |
| c | 7564 | 5.9% |
| M | 7498 | 5.9% |
| r | 7494 | 5.9% |
| A | 7024 | 5.5% |
| p | 6820 | 5.4% |
| n | 6573 | 5.2% |
| Other values (12) | 42137 |
| Value | Count | Frequency (%) |
| 2 | 51803 | |
| 1 | 47025 | |
| 0 | 46047 | |
| - | 42452 | |
| 3 | 9811 | 4.6% |
| 4 | 9322 | 4.4% |
| 5 | 2511 | 1.2% |
| 6 | 2083 | 1.0% |
| 9 | 838 | 0.4% |
| 8 | 335 | 0.2% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 339616 |
Most frequent character per block
| Value | Count | Frequency (%) |
| 2 | 51803 | |
| 1 | 47025 | |
| 0 | 46047 | |
| - | 42452 | |
| e | 10783 | 3.2% |
| a | 10775 | 3.2% |
| u | 10502 | 3.1% |
| J | 10186 | 3.0% |
| 3 | 9811 | 2.9% |
| 4 | 9322 | 2.7% |
| Other values (23) | 90910 |
last_pymnt_amnt
Real number (ℝ≥0)
| Distinct | 37260 |
|---|---|
| Distinct (%) | 87.6% |
| Missing | 1 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2613.245652 |
|---|---|
| Minimum | 0 |
| Maximum | 36115.2 |
| Zeros | 96 |
| Zeros (%) | 0.2% |
| Memory size | 332.4 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 39.18 |
| Q1 | 211.05 |
| median | 528.36 |
| Q3 | 3170.22 |
| 95-th percentile | 12018.095 |
| Maximum | 36115.2 |
| Range | 36115.2 |
| Interquartile range (IQR) | 2959.17 |
Descriptive statistics
| Standard deviation | 4385.066535 |
|---|---|
| Coefficient of variation (CV) | 1.678015433 |
| Kurtosis | 9.13496774 |
| Mean | 2613.245652 |
| Median Absolute Deviation (MAD) | 435.7 |
| Skewness | 2.750044596 |
| Sum | 111154403.8 |
| Variance | 19228808.51 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 96 | 0.2% |
| 200 | 19 | < 0.1% |
| 100 | 17 | < 0.1% |
| 50 | 17 | < 0.1% |
| 150 | 13 | < 0.1% |
| 400 | 12 | < 0.1% |
| 275.74 | 11 | < 0.1% |
| 500 | 11 | < 0.1% |
| 276.06 | 9 | < 0.1% |
| 250 | 8 | < 0.1% |
| Other values (37250) | 42322 |
| Value | Count | Frequency (%) |
| 0 | 96 | |
| 0.01 | 1 | < 0.1% |
| 0.02 | 1 | < 0.1% |
| 0.03 | 1 | < 0.1% |
| 0.06 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 36115.2 | 1 | |
| 35613.68 | 1 | |
| 35596.41 | 1 | |
| 35479.89 | 1 | |
| 35471.86 | 1 |
| Distinct | 98 |
|---|---|
| Distinct (%) | 3.6% |
| Missing | 39787 |
| Missing (%) | 93.5% |
| Memory size | 332.4 KiB |
| Mar-2011 | 107 |
|---|---|
| Apr-2011 | 101 |
| Feb-2011 | 91 |
| Jan-2011 | 79 |
| May-2011 | 77 |
| Other values (93) |
Length
| Max length | 8 |
|---|---|
| Median length | 8 |
| Mean length | 8 |
| Min length | 8 |
Characters and Unicode
| Total characters | 21992 |
|---|---|
| Distinct characters | 32 |
| Distinct categories | 4 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 2 ? |
|---|---|
| Unique (%) | 0.1% |
Sample
| 1st row | Jan-2016 |
|---|---|
| 2nd row | Sep-2013 |
| 3rd row | Feb-2016 |
| 4th row | Feb-2014 |
| 5th row | May-2014 |
| Value | Count | Frequency (%) |
| Mar-2011 | 107 | 0.3% |
| Apr-2011 | 101 | 0.2% |
| Feb-2011 | 91 | 0.2% |
| Jan-2011 | 79 | 0.2% |
| May-2011 | 77 | 0.2% |
| Dec-2010 | 71 | 0.2% |
| Jun-2011 | 66 | 0.2% |
| Sep-2011 | 63 | 0.1% |
| Aug-2011 | 57 | 0.1% |
| Nov-2010 | 55 | 0.1% |
| Other values (88) | 1982 | 4.7% |
| (Missing) | 39787 |
| Value | Count | Frequency (%) |
| mar-2011 | 107 | 3.9% |
| apr-2011 | 101 | 3.7% |
| feb-2011 | 91 | 3.3% |
| jan-2011 | 79 | 2.9% |
| may-2011 | 77 | 2.8% |
| dec-2010 | 71 | 2.6% |
| jun-2011 | 66 | 2.4% |
| sep-2011 | 63 | 2.3% |
| aug-2011 | 57 | 2.1% |
| nov-2010 | 55 | 2.0% |
| Other values (88) | 1982 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 3682 | |
| 2 | 3221 | |
| 1 | 3151 | |
| - | 2749 | |
| a | 721 | 3.3% |
| e | 702 | 3.2% |
| J | 602 | 2.7% |
| u | 599 | 2.7% |
| c | 536 | 2.4% |
| r | 515 | 2.3% |
| Other values (22) | 5514 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 10996 | |
| Lowercase Letter | 5498 | |
| Uppercase Letter | 2749 | 12.5% |
| Dash Punctuation | 2749 | 12.5% |
Most frequent character per category
| Value | Count | Frequency (%) |
| a | 721 | |
| e | 702 | |
| u | 599 | |
| c | 536 | |
| r | 515 | |
| p | 453 | |
| n | 418 | |
| t | 251 | 4.6% |
| y | 234 | 4.3% |
| o | 228 | 4.1% |
| Other values (4) | 841 |
| Value | Count | Frequency (%) |
| 0 | 3682 | |
| 2 | 3221 | |
| 1 | 3151 | |
| 3 | 372 | 3.4% |
| 9 | 312 | 2.8% |
| 8 | 106 | 1.0% |
| 5 | 79 | 0.7% |
| 4 | 63 | 0.6% |
| 6 | 10 | 0.1% |
| Value | Count | Frequency (%) |
| J | 602 | |
| M | 501 | |
| A | 465 | |
| D | 285 | |
| O | 251 | |
| N | 228 | 8.3% |
| F | 212 | 7.7% |
| S | 205 | 7.5% |
| Value | Count | Frequency (%) |
| - | 2749 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 13745 | |
| Latin | 8247 |
Most frequent character per script
| Value | Count | Frequency (%) |
| a | 721 | 8.7% |
| e | 702 | 8.5% |
| J | 602 | 7.3% |
| u | 599 | 7.3% |
| c | 536 | 6.5% |
| r | 515 | 6.2% |
| M | 501 | 6.1% |
| A | 465 | 5.6% |
| p | 453 | 5.5% |
| n | 418 | 5.1% |
| Other values (12) | 2735 |
| Value | Count | Frequency (%) |
| 0 | 3682 | |
| 2 | 3221 | |
| 1 | 3151 | |
| - | 2749 | |
| 3 | 372 | 2.7% |
| 9 | 312 | 2.3% |
| 8 | 106 | 0.8% |
| 5 | 79 | 0.6% |
| 4 | 63 | 0.5% |
| 6 | 10 | 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 21992 |
Most frequent character per block
| Value | Count | Frequency (%) |
| 0 | 3682 | |
| 2 | 3221 | |
| 1 | 3151 | |
| - | 2749 | |
| a | 721 | 3.3% |
| e | 702 | 3.2% |
| J | 602 | 2.7% |
| u | 599 | 2.7% |
| c | 536 | 2.4% |
| r | 515 | 2.3% |
| Other values (22) | 5514 |
| Distinct | 133 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 5 |
| Missing (%) | < 0.1% |
| Memory size | 332.4 KiB |
| Aug-2018 | |
|---|---|
| Oct-2016 | |
| Jul-2018 | 1233 |
| May-2018 | 734 |
| Feb-2017 | 709 |
| Other values (128) |
Length
| Max length | 8 |
|---|---|
| Median length | 8 |
| Mean length | 8 |
| Min length | 8 |
Characters and Unicode
| Total characters | 340248 |
|---|---|
| Distinct characters | 33 |
| Distinct categories | 4 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 3 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | Aug-2018 |
|---|---|
| 2nd row | Oct-2016 |
| 3rd row | Jun-2017 |
| 4th row | Apr-2016 |
| 5th row | Apr-2018 |
| Value | Count | Frequency (%) |
| Aug-2018 | 9248 | 21.7% |
| Oct-2016 | 4071 | 9.6% |
| Jul-2018 | 1233 | 2.9% |
| May-2018 | 734 | 1.7% |
| Feb-2017 | 709 | 1.7% |
| Apr-2018 | 600 | 1.4% |
| Mar-2018 | 595 | 1.4% |
| Feb-2013 | 564 | 1.3% |
| Jan-2018 | 546 | 1.3% |
| Jun-2018 | 531 | 1.2% |
| Other values (123) | 23700 |
| Value | Count | Frequency (%) |
| aug-2018 | 9248 | 21.7% |
| oct-2016 | 4071 | 9.6% |
| jul-2018 | 1233 | 2.9% |
| may-2018 | 734 | 1.7% |
| feb-2017 | 709 | 1.7% |
| apr-2018 | 600 | 1.4% |
| mar-2018 | 595 | 1.4% |
| feb-2013 | 564 | 1.3% |
| jan-2018 | 546 | 1.3% |
| jun-2018 | 531 | 1.2% |
| Other values (123) | 23700 |
Most occurring characters
| Value | Count | Frequency (%) |
| 2 | 45366 | |
| 1 | 43999 | |
| 0 | 43667 | |
| - | 42531 | |
| u | 16863 | 5.0% |
| 8 | 14066 | 4.1% |
| A | 13810 | 4.1% |
| g | 11344 | 3.3% |
| c | 8212 | 2.4% |
| a | 7664 | 2.3% |
| Other values (23) | 92726 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 170124 | |
| Lowercase Letter | 85062 | |
| Uppercase Letter | 42531 | 12.5% |
| Dash Punctuation | 42531 | 12.5% |
Most frequent character per category
| Value | Count | Frequency (%) |
| u | 16863 | |
| g | 11344 | |
| c | 8212 | |
| a | 7664 | |
| e | 7436 | |
| t | 5938 | 7.0% |
| r | 5402 | 6.4% |
| p | 4467 | 5.3% |
| n | 4428 | 5.2% |
| l | 3226 | 3.8% |
| Other values (4) | 10082 |
| Value | Count | Frequency (%) |
| 2 | 45366 | |
| 1 | 43999 | |
| 0 | 43667 | |
| 8 | 14066 | 8.3% |
| 6 | 7405 | 4.4% |
| 7 | 5040 | 3.0% |
| 4 | 3972 | 2.3% |
| 3 | 3513 | 2.1% |
| 5 | 2853 | 1.7% |
| 9 | 243 | 0.1% |
| Value | Count | Frequency (%) |
| A | 13810 | |
| J | 7654 | |
| O | 5938 | |
| M | 5529 | |
| F | 3161 | 7.4% |
| D | 2274 | 5.3% |
| N | 2164 | 5.1% |
| S | 2001 | 4.7% |
| Value | Count | Frequency (%) |
| - | 42531 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 212655 | |
| Latin | 127593 |
Most frequent character per script
| Value | Count | Frequency (%) |
| u | 16863 | |
| A | 13810 | 10.8% |
| g | 11344 | 8.9% |
| c | 8212 | 6.4% |
| a | 7664 | 6.0% |
| J | 7654 | 6.0% |
| e | 7436 | 5.8% |
| O | 5938 | 4.7% |
| t | 5938 | 4.7% |
| M | 5529 | 4.3% |
| Other values (12) | 37205 |
| Value | Count | Frequency (%) |
| 2 | 45366 | |
| 1 | 43999 | |
| 0 | 43667 | |
| - | 42531 | |
| 8 | 14066 | 6.6% |
| 6 | 7405 | 3.5% |
| 7 | 5040 | 2.4% |
| 4 | 3972 | 1.9% |
| 3 | 3513 | 1.7% |
| 5 | 2853 | 1.3% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 340248 |
Most frequent character per block
| Value | Count | Frequency (%) |
| 2 | 45366 | |
| 1 | 43999 | |
| 0 | 43667 | |
| - | 42531 | |
| u | 16863 | 5.0% |
| 8 | 14066 | 4.1% |
| A | 13810 | 4.1% |
| g | 11344 | 3.3% |
| c | 8212 | 2.4% |
| a | 7664 | 2.3% |
| Other values (23) | 92726 |
last_fico_range_high
Real number (ℝ≥0)
| Distinct | 72 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 1 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 689.9225109 |
|---|---|
| Minimum | 0 |
| Maximum | 850 |
| Zeros | 24 |
| Zeros (%) | 0.1% |
| Memory size | 332.4 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 534 |
| Q1 | 644 |
| median | 699 |
| Q3 | 749 |
| 95-th percentile | 804 |
| Maximum | 850 |
| Range | 850 |
| Interquartile range (IQR) | 105 |
Descriptive statistics
| Standard deviation | 80.81809893 |
|---|---|
| Coefficient of variation (CV) | 0.1171408349 |
| Kurtosis | 2.471258434 |
| Mean | 689.9225109 |
| Median Absolute Deviation (MAD) | 50 |
| Skewness | -0.8229792113 |
| Sum | 29345854 |
| Variance | 6531.565115 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) |
| 709 | 1256 | 3.0% |
| 694 | 1216 | 2.9% |
| 719 | 1204 | 2.8% |
| 724 | 1197 | 2.8% |
| 714 | 1175 | 2.8% |
| 704 | 1171 | 2.8% |
| 699 | 1149 | 2.7% |
| 684 | 1115 | 2.6% |
| 689 | 1077 | 2.5% |
| 734 | 1056 | 2.5% |
| Other values (62) | 30919 |
| Value | Count | Frequency (%) |
| 0 | 24 | 0.1% |
| 499 | 771 | |
| 504 | 217 | 0.5% |
| 509 | 189 | 0.4% |
| 514 | 214 | 0.5% |
| Value | Count | Frequency (%) |
| 850 | 10 | < 0.1% |
| 844 | 32 | 0.1% |
| 839 | 46 | 0.1% |
| 834 | 142 | |
| 829 | 190 |
| Distinct | 71 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 1 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 676.9520395 |
|---|---|
| Minimum | 0 |
| Maximum | 845 |
| Zeros | 795 |
| Zeros (%) | 1.9% |
| Memory size | 332.4 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 530 |
| Q1 | 640 |
| median | 695 |
| Q3 | 745 |
| 95-th percentile | 800 |
| Maximum | 845 |
| Range | 845 |
| Interquartile range (IQR) | 105 |
Descriptive statistics
| Standard deviation | 119.6477519 |
|---|---|
| Coefficient of variation (CV) | 0.1767447986 |
| Kurtosis | 16.54509905 |
| Mean | 676.9520395 |
| Median Absolute Deviation (MAD) | 50 |
| Skewness | -3.368228991 |
| Sum | 28794155 |
| Variance | 14315.58452 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) |
| 705 | 1256 | 3.0% |
| 690 | 1216 | 2.9% |
| 715 | 1204 | 2.8% |
| 720 | 1197 | 2.8% |
| 710 | 1175 | 2.8% |
| 700 | 1171 | 2.8% |
| 695 | 1149 | 2.7% |
| 680 | 1115 | 2.6% |
| 685 | 1077 | 2.5% |
| 730 | 1056 | 2.5% |
| Other values (61) | 30919 |
| Value | Count | Frequency (%) |
| 0 | 795 | |
| 500 | 217 | 0.5% |
| 505 | 189 | 0.4% |
| 510 | 214 | 0.5% |
| 515 | 214 | 0.5% |
| Value | Count | Frequency (%) |
| 845 | 10 | < 0.1% |
| 840 | 32 | 0.1% |
| 835 | 46 | 0.1% |
| 830 | 142 | |
| 825 | 190 |
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 146 |
| Missing (%) | 0.3% |
| Memory size | 332.4 KiB |
| 0.0 |
|---|
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Characters and Unicode
| Total characters | 127170 |
|---|---|
| Distinct characters | 2 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0.0 |
|---|---|
| 2nd row | 0.0 |
| 3rd row | 0.0 |
| 4th row | 0.0 |
| 5th row | 0.0 |
| Value | Count | Frequency (%) |
| 0.0 | 42390 | |
| (Missing) | 146 | 0.3% |
| Value | Count | Frequency (%) |
| 0.0 | 42390 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 84780 | |
| . | 42390 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 84780 | |
| Other Punctuation | 42390 |
Most frequent character per category
| Value | Count | Frequency (%) |
| 0 | 84780 |
| Value | Count | Frequency (%) |
| . | 42390 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 127170 |
Most frequent character per script
| Value | Count | Frequency (%) |
| 0 | 84780 | |
| . | 42390 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 127170 |
Most frequent character per block
| Value | Count | Frequency (%) |
| 0 | 84780 | |
| . | 42390 |
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 1 |
| Missing (%) | < 0.1% |
| Memory size | 332.4 KiB |
| 1.0 |
|---|
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Characters and Unicode
| Total characters | 127605 |
|---|---|
| Distinct characters | 3 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 1.0 |
|---|---|
| 2nd row | 1.0 |
| 3rd row | 1.0 |
| 4th row | 1.0 |
| 5th row | 1.0 |
| Value | Count | Frequency (%) |
| 1.0 | 42535 | |
| (Missing) | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 1.0 | 42535 |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 42535 | |
| . | 42535 | |
| 0 | 42535 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 85070 | |
| Other Punctuation | 42535 |
Most frequent character per category
| Value | Count | Frequency (%) |
| 1 | 42535 | |
| 0 | 42535 |
| Value | Count | Frequency (%) |
| . | 42535 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 127605 |
Most frequent character per script
| Value | Count | Frequency (%) |
| 1 | 42535 | |
| . | 42535 | |
| 0 | 42535 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 127605 |
Most frequent character per block
| Value | Count | Frequency (%) |
| 1 | 42535 | |
| . | 42535 | |
| 0 | 42535 |
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 1 |
| Missing (%) | < 0.1% |
| Memory size | 332.4 KiB |
| Individual |
|---|
Length
| Max length | 10 |
|---|---|
| Median length | 10 |
| Mean length | 10 |
| Min length | 10 |
Characters and Unicode
| Total characters | 425350 |
|---|---|
| Distinct characters | 8 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Individual |
|---|---|
| 2nd row | Individual |
| 3rd row | Individual |
| 4th row | Individual |
| 5th row | Individual |
| Value | Count | Frequency (%) |
| Individual | 42535 | |
| (Missing) | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| individual | 42535 |
Most occurring characters
| Value | Count | Frequency (%) |
| d | 85070 | |
| i | 85070 | |
| I | 42535 | |
| n | 42535 | |
| v | 42535 | |
| u | 42535 | |
| a | 42535 | |
| l | 42535 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 382815 | |
| Uppercase Letter | 42535 | 10.0% |
Most frequent character per category
| Value | Count | Frequency (%) |
| d | 85070 | |
| i | 85070 | |
| n | 42535 | |
| v | 42535 | |
| u | 42535 | |
| a | 42535 | |
| l | 42535 |
| Value | Count | Frequency (%) |
| I | 42535 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 425350 |
Most frequent character per script
| Value | Count | Frequency (%) |
| d | 85070 | |
| i | 85070 | |
| I | 42535 | |
| n | 42535 | |
| v | 42535 | |
| u | 42535 | |
| a | 42535 | |
| l | 42535 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 425350 |
Most frequent character per block
| Value | Count | Frequency (%) |
| d | 85070 | |
| i | 85070 | |
| I | 42535 | |
| n | 42535 | |
| v | 42535 | |
| u | 42535 | |
| a | 42535 | |
| l | 42535 |
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 30 |
| Missing (%) | 0.1% |
| Memory size | 332.4 KiB |
| 0.0 | |
|---|---|
| 1.0 | 4 |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Characters and Unicode
| Total characters | 127518 |
|---|---|
| Distinct characters | 3 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0.0 |
|---|---|
| 2nd row | 0.0 |
| 3rd row | 0.0 |
| 4th row | 0.0 |
| 5th row | 0.0 |
| Value | Count | Frequency (%) |
| 0.0 | 42502 | |
| 1.0 | 4 | < 0.1% |
| (Missing) | 30 | 0.1% |
| Value | Count | Frequency (%) |
| 0.0 | 42502 | |
| 1.0 | 4 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 85008 | |
| . | 42506 | |
| 1 | 4 | < 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 85012 | |
| Other Punctuation | 42506 |
Most frequent character per category
| Value | Count | Frequency (%) |
| 0 | 85008 | |
| 1 | 4 | < 0.1% |
| Value | Count | Frequency (%) |
| . | 42506 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 127518 |
Most frequent character per script
| Value | Count | Frequency (%) |
| 0 | 85008 | |
| . | 42506 | |
| 1 | 4 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 127518 |
Most frequent character per block
| Value | Count | Frequency (%) |
| 0 | 85008 | |
| . | 42506 | |
| 1 | 4 | < 0.1% |
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 146 |
| Missing (%) | 0.3% |
| Memory size | 332.4 KiB |
| 0.0 |
|---|
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Characters and Unicode
| Total characters | 127170 |
|---|---|
| Distinct characters | 2 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0.0 |
|---|---|
| 2nd row | 0.0 |
| 3rd row | 0.0 |
| 4th row | 0.0 |
| 5th row | 0.0 |
| Value | Count | Frequency (%) |
| 0.0 | 42390 | |
| (Missing) | 146 | 0.3% |
| Value | Count | Frequency (%) |
| 0.0 | 42390 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 84780 | |
| . | 42390 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 84780 | |
| Other Punctuation | 42390 |
Most frequent character per category
| Value | Count | Frequency (%) |
| 0 | 84780 |
| Value | Count | Frequency (%) |
| . | 42390 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 127170 |
Most frequent character per script
| Value | Count | Frequency (%) |
| 0 | 84780 | |
| . | 42390 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 127170 |
Most frequent character per block
| Value | Count | Frequency (%) |
| 0 | 84780 | |
| . | 42390 |
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 30 |
| Missing (%) | 0.1% |
| Memory size | 332.4 KiB |
| 0.0 | |
|---|---|
| 27.0 | 1 |
| 6053.0 | 1 |
Length
| Max length | 6 |
|---|---|
| Median length | 3 |
| Mean length | 3.000094104 |
| Min length | 3 |
Characters and Unicode
| Total characters | 127522 |
|---|---|
| Distinct characters | 7 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 2 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | 0.0 |
|---|---|
| 2nd row | 0.0 |
| 3rd row | 0.0 |
| 4th row | 0.0 |
| 5th row | 0.0 |
| Value | Count | Frequency (%) |
| 0.0 | 42504 | |
| 27.0 | 1 | < 0.1% |
| 6053.0 | 1 | < 0.1% |
| (Missing) | 30 | 0.1% |
| Value | Count | Frequency (%) |
| 0.0 | 42504 | |
| 27.0 | 1 | < 0.1% |
| 6053.0 | 1 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 85011 | |
| . | 42506 | |
| 2 | 1 | < 0.1% |
| 7 | 1 | < 0.1% |
| 6 | 1 | < 0.1% |
| 5 | 1 | < 0.1% |
| 3 | 1 | < 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 85016 | |
| Other Punctuation | 42506 |
Most frequent character per category
| Value | Count | Frequency (%) |
| 0 | 85011 | |
| 2 | 1 | < 0.1% |
| 7 | 1 | < 0.1% |
| 6 | 1 | < 0.1% |
| 5 | 1 | < 0.1% |
| 3 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| . | 42506 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 127522 |
Most frequent character per script
| Value | Count | Frequency (%) |
| 0 | 85011 | |
| . | 42506 | |
| 2 | 1 | < 0.1% |
| 7 | 1 | < 0.1% |
| 6 | 1 | < 0.1% |
| 5 | 1 | < 0.1% |
| 3 | 1 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 127522 |
Most frequent character per block
| Value | Count | Frequency (%) |
| 0 | 85011 | |
| . | 42506 | |
| 2 | 1 | < 0.1% |
| 7 | 1 | < 0.1% |
| 6 | 1 | < 0.1% |
| 5 | 1 | < 0.1% |
| 3 | 1 | < 0.1% |
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 1366 |
| Missing (%) | 3.2% |
| Memory size | 332.4 KiB |
| 0.0 | |
|---|---|
| 1.0 | 1846 |
| 2.0 | 8 |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Characters and Unicode
| Total characters | 123510 |
|---|---|
| Distinct characters | 4 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0.0 |
|---|---|
| 2nd row | 0.0 |
| 3rd row | 0.0 |
| 4th row | 0.0 |
| 5th row | 0.0 |
| Value | Count | Frequency (%) |
| 0.0 | 39316 | |
| 1.0 | 1846 | 4.3% |
| 2.0 | 8 | < 0.1% |
| (Missing) | 1366 | 3.2% |
| Value | Count | Frequency (%) |
| 0.0 | 39316 | |
| 1.0 | 1846 | 4.5% |
| 2.0 | 8 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 80486 | |
| . | 41170 | |
| 1 | 1846 | 1.5% |
| 2 | 8 | < 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 82340 | |
| Other Punctuation | 41170 |
Most frequent character per category
| Value | Count | Frequency (%) |
| 0 | 80486 | |
| 1 | 1846 | 2.2% |
| 2 | 8 | < 0.1% |
| Value | Count | Frequency (%) |
| . | 41170 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 123510 |
Most frequent character per script
| Value | Count | Frequency (%) |
| 0 | 80486 | |
| . | 41170 | |
| 1 | 1846 | 1.5% |
| 2 | 8 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 123510 |
Most frequent character per block
| Value | Count | Frequency (%) |
| 0 | 80486 | |
| . | 41170 | |
| 1 | 1846 | 1.5% |
| 2 | 8 | < 0.1% |
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 106 |
| Missing (%) | 0.2% |
| Memory size | 332.4 KiB |
| 0.0 | |
|---|---|
| 1.0 | 1 |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Characters and Unicode
| Total characters | 127290 |
|---|---|
| Distinct characters | 3 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | 0.0 |
|---|---|
| 2nd row | 0.0 |
| 3rd row | 0.0 |
| 4th row | 0.0 |
| 5th row | 0.0 |
| Value | Count | Frequency (%) |
| 0.0 | 42429 | |
| 1.0 | 1 | < 0.1% |
| (Missing) | 106 | 0.2% |
| Value | Count | Frequency (%) |
| 0.0 | 42429 | |
| 1.0 | 1 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 84859 | |
| . | 42430 | |
| 1 | 1 | < 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 84860 | |
| Other Punctuation | 42430 |
Most frequent character per category
| Value | Count | Frequency (%) |
| 0 | 84859 | |
| 1 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| . | 42430 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 127290 |
Most frequent character per script
| Value | Count | Frequency (%) |
| 0 | 84859 | |
| . | 42430 | |
| 1 | 1 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 127290 |
Most frequent character per block
| Value | Count | Frequency (%) |
| 0 | 84859 | |
| . | 42430 | |
| 1 | 1 | < 0.1% |
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 1 |
| Missing (%) | < 0.1% |
| Memory size | 83.2 KiB |
| False | |
|---|---|
| (Missing) | 1 |
| Value | Count | Frequency (%) |
| False | 42535 | |
| (Missing) | 1 | < 0.1% |
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 1 |
| Missing (%) | < 0.1% |
| Memory size | 332.4 KiB |
| Cash |
|---|
Length
| Max length | 4 |
|---|---|
| Median length | 4 |
| Mean length | 4 |
| Min length | 4 |
Characters and Unicode
| Total characters | 170140 |
|---|---|
| Distinct characters | 4 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Cash |
|---|---|
| 2nd row | Cash |
| 3rd row | Cash |
| 4th row | Cash |
| 5th row | Cash |
| Value | Count | Frequency (%) |
| Cash | 42535 | |
| (Missing) | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| cash | 42535 |
Most occurring characters
| Value | Count | Frequency (%) |
| C | 42535 | |
| a | 42535 | |
| s | 42535 | |
| h | 42535 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 127605 | |
| Uppercase Letter | 42535 | 25.0% |
Most frequent character per category
| Value | Count | Frequency (%) |
| a | 42535 | |
| s | 42535 | |
| h | 42535 |
| Value | Count | Frequency (%) |
| C | 42535 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 170140 |
Most frequent character per script
| Value | Count | Frequency (%) |
| C | 42535 | |
| a | 42535 | |
| s | 42535 | |
| h | 42535 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 170140 |
Most frequent character per block
| Value | Count | Frequency (%) |
| C | 42535 | |
| a | 42535 | |
| s | 42535 | |
| h | 42535 |
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 1 |
| Missing (%) | < 0.1% |
| Memory size | 83.2 KiB |
| False | |
|---|---|
| True | 160 |
| (Missing) | 1 |
| Value | Count | Frequency (%) |
| False | 42375 | |
| True | 160 | 0.4% |
| (Missing) | 1 | < 0.1% |
| Distinct | 63 |
|---|---|
| Distinct (%) | 39.4% |
| Missing | 42376 |
| Missing (%) | 99.6% |
| Memory size | 332.4 KiB |
| Jun-2017 | |
|---|---|
| Jan-2015 | 7 |
| Apr-2017 | 7 |
| Sep-2015 | 6 |
| Oct-2013 | 5 |
| Other values (58) |
Length
| Max length | 8 |
|---|---|
| Median length | 8 |
| Mean length | 8 |
| Min length | 8 |
Characters and Unicode
| Total characters | 1280 |
|---|---|
| Distinct characters | 32 |
| Distinct categories | 4 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 28 ? |
|---|---|
| Unique (%) | 17.5% |
Sample
| 1st row | Feb-2016 |
|---|---|
| 2nd row | May-2014 |
| 3rd row | Apr-2014 |
| 4th row | Apr-2016 |
| 5th row | Feb-2015 |
| Value | Count | Frequency (%) |
| Jun-2017 | 18 | < 0.1% |
| Jan-2015 | 7 | < 0.1% |
| Apr-2017 | 7 | < 0.1% |
| Sep-2015 | 6 | < 0.1% |
| Oct-2013 | 5 | < 0.1% |
| Jul-2014 | 5 | < 0.1% |
| Feb-2015 | 5 | < 0.1% |
| May-2014 | 5 | < 0.1% |
| Nov-2013 | 4 | < 0.1% |
| Apr-2015 | 4 | < 0.1% |
| Other values (53) | 94 | 0.2% |
| (Missing) | 42376 |
| Value | Count | Frequency (%) |
| jun-2017 | 18 | 11.2% |
| apr-2017 | 7 | 4.4% |
| jan-2015 | 7 | 4.4% |
| sep-2015 | 6 | 3.8% |
| jul-2014 | 5 | 3.1% |
| oct-2013 | 5 | 3.1% |
| may-2014 | 5 | 3.1% |
| feb-2015 | 5 | 3.1% |
| apr-2014 | 4 | 2.5% |
| nov-2013 | 4 | 2.5% |
| Other values (53) | 94 |
Most occurring characters
| Value | Count | Frequency (%) |
| 2 | 171 | |
| 1 | 163 | |
| 0 | 161 | |
| - | 160 | |
| J | 50 | 3.9% |
| u | 50 | 3.9% |
| n | 40 | 3.1% |
| e | 38 | 3.0% |
| p | 35 | 2.7% |
| 4 | 33 | 2.6% |
| Other values (22) | 379 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 640 | |
| Lowercase Letter | 320 | |
| Uppercase Letter | 160 | 12.5% |
| Dash Punctuation | 160 | 12.5% |
Most frequent character per category
| Value | Count | Frequency (%) |
| u | 50 | |
| n | 40 | |
| e | 38 | |
| p | 35 | |
| r | 33 | |
| a | 29 | |
| c | 22 | |
| b | 15 | 4.7% |
| t | 14 | 4.4% |
| l | 10 | 3.1% |
| Other values (4) | 34 |
| Value | Count | Frequency (%) |
| 2 | 171 | |
| 1 | 163 | |
| 0 | 161 | |
| 4 | 33 | 5.2% |
| 7 | 32 | 5.0% |
| 5 | 31 | 4.8% |
| 3 | 30 | 4.7% |
| 6 | 13 | 2.0% |
| 8 | 6 | 0.9% |
| Value | Count | Frequency (%) |
| J | 50 | |
| A | 28 | |
| M | 21 | |
| F | 15 | 9.4% |
| S | 15 | 9.4% |
| O | 14 | 8.8% |
| N | 9 | 5.6% |
| D | 8 | 5.0% |
| Value | Count | Frequency (%) |
| - | 160 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 800 | |
| Latin | 480 |
Most frequent character per script
| Value | Count | Frequency (%) |
| J | 50 | 10.4% |
| u | 50 | 10.4% |
| n | 40 | 8.3% |
| e | 38 | 7.9% |
| p | 35 | 7.3% |
| r | 33 | 6.9% |
| a | 29 | 6.0% |
| A | 28 | 5.8% |
| c | 22 | 4.6% |
| M | 21 | 4.4% |
| Other values (12) | 134 |
| Value | Count | Frequency (%) |
| 2 | 171 | |
| 1 | 163 | |
| 0 | 161 | |
| - | 160 | |
| 4 | 33 | 4.1% |
| 7 | 32 | 4.0% |
| 5 | 31 | 3.9% |
| 3 | 30 | 3.8% |
| 6 | 13 | 1.6% |
| 8 | 6 | 0.8% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1280 |
Most frequent character per block
| Value | Count | Frequency (%) |
| 2 | 171 | |
| 1 | 163 | |
| 0 | 161 | |
| - | 160 | |
| J | 50 | 3.9% |
| u | 50 | 3.9% |
| n | 40 | 3.1% |
| e | 38 | 3.0% |
| p | 35 | 2.7% |
| 4 | 33 | 2.6% |
| Other values (22) | 379 |
| Distinct | 3 |
|---|---|
| Distinct (%) | 1.9% |
| Missing | 42376 |
| Missing (%) | 99.6% |
| Memory size | 332.4 KiB |
| COMPLETE | |
|---|---|
| BROKEN | |
| ACTIVE | 3 |
Length
| Max length | 8 |
|---|---|
| Median length | 8 |
| Mean length | 7.775 |
| Min length | 6 |
Characters and Unicode
| Total characters | 1244 |
|---|---|
| Distinct characters | 14 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | COMPLETE |
|---|---|
| 2nd row | COMPLETE |
| 3rd row | COMPLETE |
| 4th row | COMPLETE |
| 5th row | COMPLETE |
| Value | Count | Frequency (%) |
| COMPLETE | 142 | 0.3% |
| BROKEN | 15 | < 0.1% |
| ACTIVE | 3 | < 0.1% |
| (Missing) | 42376 |
| Value | Count | Frequency (%) |
| complete | 142 | |
| broken | 15 | 9.4% |
| active | 3 | 1.9% |
Most occurring characters
| Value | Count | Frequency (%) |
| E | 302 | |
| O | 157 | |
| C | 145 | |
| T | 145 | |
| M | 142 | |
| P | 142 | |
| L | 142 | |
| B | 15 | 1.2% |
| R | 15 | 1.2% |
| K | 15 | 1.2% |
| Other values (4) | 24 | 1.9% |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 1244 |
Most frequent character per category
| Value | Count | Frequency (%) |
| E | 302 | |
| O | 157 | |
| C | 145 | |
| T | 145 | |
| M | 142 | |
| P | 142 | |
| L | 142 | |
| B | 15 | 1.2% |
| R | 15 | 1.2% |
| K | 15 | 1.2% |
| Other values (4) | 24 | 1.9% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 1244 |
Most frequent character per script
| Value | Count | Frequency (%) |
| E | 302 | |
| O | 157 | |
| C | 145 | |
| T | 145 | |
| M | 142 | |
| P | 142 | |
| L | 142 | |
| B | 15 | 1.2% |
| R | 15 | 1.2% |
| K | 15 | 1.2% |
| Other values (4) | 24 | 1.9% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1244 |
Most frequent character per block
| Value | Count | Frequency (%) |
| E | 302 | |
| O | 157 | |
| C | 145 | |
| T | 145 | |
| M | 142 | |
| P | 142 | |
| L | 142 | |
| B | 15 | 1.2% |
| R | 15 | 1.2% |
| K | 15 | 1.2% |
| Other values (4) | 24 | 1.9% |
| Distinct | 61 |
|---|---|
| Distinct (%) | 38.1% |
| Missing | 42376 |
| Missing (%) | 99.6% |
| Memory size | 332.4 KiB |
| Sep-2013 | 8 |
|---|---|
| Oct-2013 | 8 |
| Jan-2015 | 8 |
| Jul-2014 | 6 |
| Mar-2013 | 6 |
| Other values (56) |
Length
| Max length | 8 |
|---|---|
| Median length | 8 |
| Mean length | 8 |
| Min length | 8 |
Characters and Unicode
| Total characters | 1280 |
|---|---|
| Distinct characters | 33 |
| Distinct categories | 4 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 22 ? |
|---|---|
| Unique (%) | 13.8% |
Sample
| 1st row | Feb-2015 |
|---|---|
| 2nd row | Nov-2013 |
| 3rd row | Mar-2014 |
| 4th row | May-2015 |
| 5th row | Aug-2014 |
| Value | Count | Frequency (%) |
| Sep-2013 | 8 | < 0.1% |
| Oct-2013 | 8 | < 0.1% |
| Jan-2015 | 8 | < 0.1% |
| Jul-2014 | 6 | < 0.1% |
| Mar-2013 | 6 | < 0.1% |
| Nov-2013 | 5 | < 0.1% |
| Jul-2013 | 5 | < 0.1% |
| May-2015 | 5 | < 0.1% |
| Jun-2014 | 5 | < 0.1% |
| Aug-2014 | 4 | < 0.1% |
| Other values (51) | 100 | 0.2% |
| (Missing) | 42376 |
| Value | Count | Frequency (%) |
| sep-2013 | 8 | 5.0% |
| oct-2013 | 8 | 5.0% |
| jan-2015 | 8 | 5.0% |
| jul-2014 | 6 | 3.8% |
| mar-2013 | 6 | 3.8% |
| jul-2013 | 5 | 3.1% |
| may-2015 | 5 | 3.1% |
| nov-2013 | 5 | 3.1% |
| jun-2014 | 5 | 3.1% |
| jun-2015 | 4 | 2.5% |
| Other values (51) | 100 |
Most occurring characters
| Value | Count | Frequency (%) |
| 2 | 184 | |
| 1 | 164 | |
| 0 | 162 | |
| - | 160 | |
| a | 47 | 3.7% |
| J | 47 | 3.7% |
| 3 | 45 | 3.5% |
| u | 44 | 3.4% |
| 4 | 37 | 2.9% |
| e | 34 | 2.7% |
| Other values (23) | 356 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 640 | |
| Lowercase Letter | 320 | |
| Uppercase Letter | 160 | 12.5% |
| Dash Punctuation | 160 | 12.5% |
Most frequent character per category
| Value | Count | Frequency (%) |
| a | 47 | |
| u | 44 | |
| e | 34 | |
| n | 31 | |
| r | 27 | |
| p | 24 | |
| c | 22 | |
| y | 16 | 5.0% |
| t | 16 | 5.0% |
| l | 16 | 5.0% |
| Other values (4) | 43 |
| Value | Count | Frequency (%) |
| 2 | 184 | |
| 1 | 164 | |
| 0 | 162 | |
| 3 | 45 | 7.0% |
| 4 | 37 | 5.8% |
| 5 | 26 | 4.1% |
| 7 | 9 | 1.4% |
| 6 | 7 | 1.1% |
| 8 | 5 | 0.8% |
| 9 | 1 | 0.2% |
| Value | Count | Frequency (%) |
| J | 47 | |
| M | 32 | |
| A | 23 | |
| O | 16 | 10.0% |
| F | 15 | 9.4% |
| S | 13 | 8.1% |
| N | 8 | 5.0% |
| D | 6 | 3.8% |
| Value | Count | Frequency (%) |
| - | 160 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 800 | |
| Latin | 480 |
Most frequent character per script
| Value | Count | Frequency (%) |
| a | 47 | 9.8% |
| J | 47 | 9.8% |
| u | 44 | 9.2% |
| e | 34 | 7.1% |
| M | 32 | 6.7% |
| n | 31 | 6.5% |
| r | 27 | 5.6% |
| p | 24 | 5.0% |
| A | 23 | 4.8% |
| c | 22 | 4.6% |
| Other values (12) | 149 |
| Value | Count | Frequency (%) |
| 2 | 184 | |
| 1 | 164 | |
| 0 | 162 | |
| - | 160 | |
| 3 | 45 | 5.6% |
| 4 | 37 | 4.6% |
| 5 | 26 | 3.2% |
| 7 | 9 | 1.1% |
| 6 | 7 | 0.9% |
| 8 | 5 | 0.6% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1280 |
Most frequent character per block
| Value | Count | Frequency (%) |
| 2 | 184 | |
| 1 | 164 | |
| 0 | 162 | |
| - | 160 | |
| a | 47 | 3.7% |
| J | 47 | 3.7% |
| 3 | 45 | 3.5% |
| u | 44 | 3.4% |
| 4 | 37 | 2.9% |
| e | 34 | 2.7% |
| Other values (23) | 356 |
| Distinct | 143 |
|---|---|
| Distinct (%) | 89.4% |
| Missing | 42376 |
| Missing (%) | 99.6% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4272.137875 |
|---|---|
| Minimum | 193.29 |
| Maximum | 14798.2 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 332.4 KiB |
Quantile statistics
| Minimum | 193.29 |
|---|---|
| 5-th percentile | 704.646 |
| Q1 | 1842.75 |
| median | 3499.35 |
| Q3 | 5701.1 |
| 95-th percentile | 11040 |
| Maximum | 14798.2 |
| Range | 14604.91 |
| Interquartile range (IQR) | 3858.35 |
Descriptive statistics
| Standard deviation | 3119.373774 |
|---|---|
| Coefficient of variation (CV) | 0.7301669246 |
| Kurtosis | 1.155413328 |
| Mean | 4272.137875 |
| Median Absolute Deviation (MAD) | 1889 |
| Skewness | 1.182311522 |
| Sum | 683542.06 |
| Variance | 9730492.741 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) |
| 1800 | 3 | < 0.1% |
| 8000 | 3 | < 0.1% |
| 6500 | 3 | < 0.1% |
| 5000 | 3 | < 0.1% |
| 1600 | 2 | < 0.1% |
| 2100 | 2 | < 0.1% |
| 4000 | 2 | < 0.1% |
| 12000 | 2 | < 0.1% |
| 1200 | 2 | < 0.1% |
| 3300 | 2 | < 0.1% |
| Other values (133) | 136 | 0.3% |
| (Missing) | 42376 |
| Value | Count | Frequency (%) |
| 193.29 | 1 | |
| 295.8 | 1 | |
| 300 | 1 | |
| 500 | 1 | |
| 552.77 | 1 |
| Value | Count | Frequency (%) |
| 14798.2 | 1 | |
| 14161.28 | 1 | |
| 13066.15 | 1 | |
| 12426.22 | 1 | |
| 12390.99 | 1 |
| Distinct | 123 |
|---|---|
| Distinct (%) | 76.9% |
| Missing | 42376 |
| Missing (%) | 99.6% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 49.905875 |
|---|---|
| Minimum | 10.69 |
| Maximum | 92.74 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 332.4 KiB |
Quantile statistics
| Minimum | 10.69 |
|---|---|
| 5-th percentile | 28.489 |
| Q1 | 40 |
| median | 49.97 |
| Q3 | 60.6525 |
| 95-th percentile | 76.4865 |
| Maximum | 92.74 |
| Range | 82.05 |
| Interquartile range (IQR) | 20.6525 |
Descriptive statistics
| Standard deviation | 15.5636903 |
|---|---|
| Coefficient of variation (CV) | 0.3118608842 |
| Kurtosis | 0.2054606155 |
| Mean | 49.905875 |
| Median Absolute Deviation (MAD) | 9.97 |
| Skewness | 0.4461853083 |
| Sum | 7984.94 |
| Variance | 242.2284558 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) |
| 50 | 13 | < 0.1% |
| 40 | 9 | < 0.1% |
| 65 | 4 | < 0.1% |
| 45 | 4 | < 0.1% |
| 49.98 | 3 | < 0.1% |
| 44.99 | 3 | < 0.1% |
| 20 | 3 | < 0.1% |
| 60 | 2 | < 0.1% |
| 69 | 2 | < 0.1% |
| 42.06 | 2 | < 0.1% |
| Other values (113) | 115 | 0.3% |
| (Missing) | 42376 |
| Value | Count | Frequency (%) |
| 10.69 | 1 | < 0.1% |
| 19.46 | 1 | < 0.1% |
| 20 | 3 | |
| 22.04 | 1 | < 0.1% |
| 24.99 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 92.74 | 1 | |
| 91.7 | 1 | |
| 90.02 | 1 | |
| 87.25 | 1 | |
| 86.41 | 1 |
| Distinct | 11 |
|---|---|
| Distinct (%) | 6.9% |
| Missing | 42376 |
| Missing (%) | 99.6% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.2 |
|---|---|
| Minimum | 0 |
| Maximum | 24 |
| Zeros | 126 |
| Zeros (%) | 0.3% |
| Memory size | 332.4 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 8.05 |
| Maximum | 24 |
| Range | 24 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 4.085254971 |
|---|---|
| Coefficient of variation (CV) | 3.404379142 |
| Kurtosis | 19.36316121 |
| Mean | 1.2 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 4.358151949 |
| Sum | 192 |
| Variance | 16.68930818 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 126 | 0.3% |
| 1 | 17 | < 0.1% |
| 2 | 5 | < 0.1% |
| 6 | 3 | < 0.1% |
| 24 | 2 | < 0.1% |
| 18 | 2 | < 0.1% |
| 8 | 1 | < 0.1% |
| 9 | 1 | < 0.1% |
| 23 | 1 | < 0.1% |
| 11 | 1 | < 0.1% |
| (Missing) | 42376 |
| Value | Count | Frequency (%) |
| 0 | 126 | |
| 1 | 17 | < 0.1% |
| 2 | 5 | < 0.1% |
| 6 | 3 | < 0.1% |
| 8 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 24 | 2 | |
| 23 | 1 | |
| 18 | 2 | |
| 12 | 1 | |
| 11 | 1 |
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
Phik (φk)
Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.Cramér's V (φc)
Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.First rows
| id | member_id | loan_amnt | funded_amnt | funded_amnt_inv | term | int_rate | installment | grade | sub_grade | emp_title | emp_length | home_ownership | annual_inc | verification_status | issue_d | loan_status | pymnt_plan | url | desc | purpose | title | zip_code | addr_state | dti | delinq_2yrs | earliest_cr_line | fico_range_low | fico_range_high | inq_last_6mths | mths_since_last_delinq | mths_since_last_record | open_acc | pub_rec | revol_bal | revol_util | total_acc | initial_list_status | out_prncp | out_prncp_inv | total_pymnt | total_pymnt_inv | total_rec_prncp | total_rec_int | total_rec_late_fee | recoveries | collection_recovery_fee | last_pymnt_d | last_pymnt_amnt | next_pymnt_d | last_credit_pull_d | last_fico_range_high | last_fico_range_low | collections_12_mths_ex_med | mths_since_last_major_derog | policy_code | application_type | annual_inc_joint | dti_joint | verification_status_joint | acc_now_delinq | tot_coll_amt | tot_cur_bal | open_acc_6m | open_act_il | open_il_12m | open_il_24m | mths_since_rcnt_il | total_bal_il | il_util | open_rv_12m | open_rv_24m | max_bal_bc | all_util | total_rev_hi_lim | inq_fi | total_cu_tl | inq_last_12m | acc_open_past_24mths | avg_cur_bal | bc_open_to_buy | bc_util | chargeoff_within_12_mths | delinq_amnt | mo_sin_old_il_acct | mo_sin_old_rev_tl_op | mo_sin_rcnt_rev_tl_op | mo_sin_rcnt_tl | mort_acc | mths_since_recent_bc | mths_since_recent_bc_dlq | mths_since_recent_inq | mths_since_recent_revol_delinq | num_accts_ever_120_pd | num_actv_bc_tl | num_actv_rev_tl | num_bc_sats | num_bc_tl | num_il_tl | num_op_rev_tl | num_rev_accts | num_rev_tl_bal_gt_0 | num_sats | num_tl_120dpd_2m | num_tl_30dpd | num_tl_90g_dpd_24m | num_tl_op_past_12m | pct_tl_nvr_dlq | percent_bc_gt_75 | pub_rec_bankruptcies | tax_liens | tot_hi_cred_lim | total_bal_ex_mort | total_bc_limit | total_il_high_credit_limit | revol_bal_joint | sec_app_fico_range_low | sec_app_fico_range_high | sec_app_earliest_cr_line | sec_app_inq_last_6mths | sec_app_mort_acc | sec_app_open_acc | sec_app_revol_util | sec_app_open_act_il | sec_app_num_rev_accts | sec_app_chargeoff_within_12_mths | sec_app_collections_12_mths_ex_med | sec_app_mths_since_last_major_derog | hardship_flag | hardship_type | hardship_reason | hardship_status | deferral_term | hardship_amount | hardship_start_date | hardship_end_date | payment_plan_start_date | hardship_length | hardship_dpd | hardship_loan_status | orig_projected_additional_accrued_interest | hardship_payoff_balance_amount | hardship_last_payment_amount | disbursement_method | debt_settlement_flag | debt_settlement_flag_date | settlement_status | settlement_date | settlement_amount | settlement_percentage | settlement_term | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 1077501 | NaN | 5000.0 | 5000.0 | 4975.0 | 36 months | 10.65% | 162.87 | B | B2 | NaN | 10+ years | RENT | 24000.0 | Verified | Dec-2011 | Fully Paid | n | https://lendingclub.com/browse/loanDetail.action?loan_id=1077501 | Borrower added on 12/22/11 > I need to upgrade my business technologies.<br> | credit_card | Computer | 860xx | AZ | 27.65 | 0.0 | Jan-1985 | 735.0 | 739.0 | 1.0 | 0.0 | NaN | 3.0 | 0.0 | 13648.0 | 83.7% | 9.0 | f | 0.0 | 0.0 | 5863.155187 | 5833.84 | 5000.00 | 863.16 | 0.00 | 0.00 | 0.00 | Jan-2015 | 171.62 | NaN | Aug-2018 | 739.0 | 735.0 | 0.0 | NaN | 1.0 | Individual | NaN | NaN | NaN | 0.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 0.0 | 0.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 0.0 | 0.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | N | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | Cash | N | NaN | NaN | NaN | NaN | NaN | NaN |
| 1 | 1077430 | NaN | 2500.0 | 2500.0 | 2500.0 | 60 months | 15.27% | 59.83 | C | C4 | Ryder | < 1 year | RENT | 30000.0 | Source Verified | Dec-2011 | Charged Off | n | https://lendingclub.com/browse/loanDetail.action?loan_id=1077430 | Borrower added on 12/22/11 > I plan to use this money to finance the motorcycle i am looking at. I plan to have it paid off as soon as possible/when i sell my old bike. I only need this money because the deal im looking at is to good to pass up.<br><br> Borrower added on 12/22/11 > I plan to use this money to finance the motorcycle i am looking at. I plan to have it paid off as soon as possible/when i sell my old bike.I only need this money because the deal im looking at is to good to pass up. I have finished college with an associates degree in business and its takingmeplaces<br> | car | bike | 309xx | GA | 1.00 | 0.0 | Apr-1999 | 740.0 | 744.0 | 5.0 | 0.0 | NaN | 3.0 | 0.0 | 1687.0 | 9.4% | 4.0 | f | 0.0 | 0.0 | 1014.530000 | 1014.53 | 456.46 | 435.17 | 0.00 | 122.90 | 1.11 | Apr-2013 | 119.66 | NaN | Oct-2016 | 499.0 | 0.0 | 0.0 | NaN | 1.0 | Individual | NaN | NaN | NaN | 0.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 0.0 | 0.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 0.0 | 0.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | N | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | Cash | N | NaN | NaN | NaN | NaN | NaN | NaN |
| 2 | 1077175 | NaN | 2400.0 | 2400.0 | 2400.0 | 36 months | 15.96% | 84.33 | C | C5 | NaN | 10+ years | RENT | 12252.0 | Not Verified | Dec-2011 | Fully Paid | n | https://lendingclub.com/browse/loanDetail.action?loan_id=1077175 | NaN | small_business | real estate business | 606xx | IL | 8.72 | 0.0 | Nov-2001 | 735.0 | 739.0 | 2.0 | 0.0 | NaN | 2.0 | 0.0 | 2956.0 | 98.5% | 10.0 | f | 0.0 | 0.0 | 3005.666844 | 3005.67 | 2400.00 | 605.67 | 0.00 | 0.00 | 0.00 | Jun-2014 | 649.91 | NaN | Jun-2017 | 739.0 | 735.0 | 0.0 | NaN | 1.0 | Individual | NaN | NaN | NaN | 0.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 0.0 | 0.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 0.0 | 0.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | N | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | Cash | N | NaN | NaN | NaN | NaN | NaN | NaN |
| 3 | 1076863 | NaN | 10000.0 | 10000.0 | 10000.0 | 36 months | 13.49% | 339.31 | C | C1 | AIR RESOURCES BOARD | 10+ years | RENT | 49200.0 | Source Verified | Dec-2011 | Fully Paid | n | https://lendingclub.com/browse/loanDetail.action?loan_id=1076863 | Borrower added on 12/21/11 > to pay for property tax (borrow from friend, need to pay back) & central A/C need to be replace. I'm very sorry to let my loan expired last time.<br> | other | personel | 917xx | CA | 20.00 | 0.0 | Feb-1996 | 690.0 | 694.0 | 1.0 | 35.0 | NaN | 10.0 | 0.0 | 5598.0 | 21% | 37.0 | f | 0.0 | 0.0 | 12231.890000 | 12231.89 | 10000.00 | 2214.92 | 16.97 | 0.00 | 0.00 | Jan-2015 | 357.48 | NaN | Apr-2016 | 604.0 | 600.0 | 0.0 | NaN | 1.0 | Individual | NaN | NaN | NaN | 0.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 0.0 | 0.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 0.0 | 0.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | N | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | Cash | N | NaN | NaN | NaN | NaN | NaN | NaN |
| 4 | 1075358 | NaN | 3000.0 | 3000.0 | 3000.0 | 60 months | 12.69% | 67.79 | B | B5 | University Medical Group | 1 year | RENT | 80000.0 | Source Verified | Dec-2011 | Fully Paid | n | https://lendingclub.com/browse/loanDetail.action?loan_id=1075358 | Borrower added on 12/21/11 > I plan on combining three large interest bills together and freeing up some extra each month to pay toward other bills. I've always been a good payor but have found myself needing to make adjustments to my budget due to a medical scare. My job is very stable, I love it.<br> | other | Personal | 972xx | OR | 17.94 | 0.0 | Jan-1996 | 695.0 | 699.0 | 0.0 | 38.0 | NaN | 15.0 | 0.0 | 27783.0 | 53.9% | 38.0 | f | 0.0 | 0.0 | 4066.908161 | 4066.91 | 3000.00 | 1066.91 | 0.00 | 0.00 | 0.00 | Jan-2017 | 67.30 | NaN | Apr-2018 | 684.0 | 680.0 | 0.0 | NaN | 1.0 | Individual | NaN | NaN | NaN | 0.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 0.0 | 0.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 0.0 | 0.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | N | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | Cash | N | NaN | NaN | NaN | NaN | NaN | NaN |
| 5 | 1075269 | NaN | 5000.0 | 5000.0 | 5000.0 | 36 months | 7.90% | 156.46 | A | A4 | Veolia Transportaton | 3 years | RENT | 36000.0 | Source Verified | Dec-2011 | Fully Paid | n | https://lendingclub.com/browse/loanDetail.action?loan_id=1075269 | NaN | wedding | My wedding loan I promise to pay back | 852xx | AZ | 11.20 | 0.0 | Nov-2004 | 730.0 | 734.0 | 3.0 | 0.0 | NaN | 9.0 | 0.0 | 7963.0 | 28.3% | 12.0 | f | 0.0 | 0.0 | 5632.210000 | 5632.21 | 5000.00 | 632.21 | 0.00 | 0.00 | 0.00 | Jan-2015 | 161.03 | NaN | Feb-2017 | 564.0 | 560.0 | 0.0 | NaN | 1.0 | Individual | NaN | NaN | NaN | 0.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 0.0 | 0.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 0.0 | 0.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | N | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | Cash | N | NaN | NaN | NaN | NaN | NaN | NaN |
| 6 | 1069639 | NaN | 7000.0 | 7000.0 | 7000.0 | 60 months | 15.96% | 170.08 | C | C5 | Southern Star Photography | 8 years | RENT | 47004.0 | Not Verified | Dec-2011 | Fully Paid | n | https://lendingclub.com/browse/loanDetail.action?loan_id=1069639 | Borrower added on 12/18/11 > I am planning on using the funds to pay off two retail credit cards with 24.99% interest rates, as well as a major bank credit card with a 18.99% rate. I pay all my bills on time, looking for a lower combined payment and lower monthly payment.<br> | debt_consolidation | Loan | 280xx | NC | 23.51 | 0.0 | Jul-2005 | 690.0 | 694.0 | 1.0 | 0.0 | NaN | 7.0 | 0.0 | 17726.0 | 85.6% | 11.0 | f | 0.0 | 0.0 | 10137.840008 | 10137.84 | 7000.00 | 3137.84 | 0.00 | 0.00 | 0.00 | May-2016 | 1313.76 | NaN | Sep-2016 | 654.0 | 650.0 | 0.0 | NaN | 1.0 | Individual | NaN | NaN | NaN | 0.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 0.0 | 0.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 0.0 | 0.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | N | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | Cash | N | NaN | NaN | NaN | NaN | NaN | NaN |
| 7 | 1072053 | NaN | 3000.0 | 3000.0 | 3000.0 | 36 months | 18.64% | 109.43 | E | E1 | MKC Accounting | 9 years | RENT | 48000.0 | Source Verified | Dec-2011 | Fully Paid | n | https://lendingclub.com/browse/loanDetail.action?loan_id=1072053 | Borrower added on 12/16/11 > Downpayment for a car.<br> | car | Car Downpayment | 900xx | CA | 5.35 | 0.0 | Jan-2007 | 660.0 | 664.0 | 2.0 | 0.0 | NaN | 4.0 | 0.0 | 8221.0 | 87.5% | 4.0 | f | 0.0 | 0.0 | 3939.135294 | 3939.14 | 3000.00 | 939.14 | 0.00 | 0.00 | 0.00 | Jan-2015 | 111.34 | NaN | Dec-2014 | 689.0 | 685.0 | 0.0 | NaN | 1.0 | Individual | NaN | NaN | NaN | 0.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 0.0 | 0.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 0.0 | 0.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | N | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | Cash | N | NaN | NaN | NaN | NaN | NaN | NaN |
| 8 | 1071795 | NaN | 5600.0 | 5600.0 | 5600.0 | 60 months | 21.28% | 152.39 | F | F2 | NaN | 4 years | OWN | 40000.0 | Source Verified | Dec-2011 | Charged Off | n | https://lendingclub.com/browse/loanDetail.action?loan_id=1071795 | Borrower added on 12/21/11 > I own a small home-based judgment collection business. I have 5 years experience collecting debts. I am now going from a home office to a small office. I also plan to buy a small debt portfolio (eg. $10K for $1M of debt) <br>My score is not A+ because I own my home and have no mortgage.<br> | small_business | Expand Business & Buy Debt Portfolio | 958xx | CA | 5.55 | 0.0 | Apr-2004 | 675.0 | 679.0 | 2.0 | 0.0 | NaN | 11.0 | 0.0 | 5210.0 | 32.6% | 13.0 | f | 0.0 | 0.0 | 647.500000 | 647.50 | 162.02 | 294.94 | 0.00 | 190.54 | 2.09 | Apr-2012 | 152.39 | NaN | Oct-2016 | 499.0 | 0.0 | 0.0 | NaN | 1.0 | Individual | NaN | NaN | NaN | 0.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 0.0 | 0.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 0.0 | 0.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | N | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | Cash | N | NaN | NaN | NaN | NaN | NaN | NaN |
| 9 | 1071570 | NaN | 5375.0 | 5375.0 | 5350.0 | 60 months | 12.69% | 121.45 | B | B5 | Starbucks | < 1 year | RENT | 15000.0 | Verified | Dec-2011 | Charged Off | n | https://lendingclub.com/browse/loanDetail.action?loan_id=1071570 | Borrower added on 12/16/11 > I'm trying to build up my credit history. I live with my brother and have no car payment or credit cards. I am in community college and work full time. Im going to use the money to make some repairs around the house and get some maintenance done on my car.<br><br> Borrower added on 12/20/11 > $1000 down only $4375 to go. Thanks to everyone that invested so far, looking forward to surprising my brother with the fixes around the house.<br> | other | Building my credit history. | 774xx | TX | 18.08 | 0.0 | Sep-2004 | 725.0 | 729.0 | 0.0 | 0.0 | NaN | 2.0 | 0.0 | 9279.0 | 36.5% | 3.0 | f | 0.0 | 0.0 | 1484.590000 | 1477.70 | 673.48 | 533.42 | 0.00 | 277.69 | 2.52 | Nov-2012 | 121.45 | NaN | Dec-2016 | 504.0 | 500.0 | 0.0 | NaN | 1.0 | Individual | NaN | NaN | NaN | 0.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 0.0 | 0.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 0.0 | 0.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | N | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | Cash | N | NaN | NaN | NaN | NaN | NaN | NaN |
Last rows
| id | member_id | loan_amnt | funded_amnt | funded_amnt_inv | term | int_rate | installment | grade | sub_grade | emp_title | emp_length | home_ownership | annual_inc | verification_status | issue_d | loan_status | pymnt_plan | url | desc | purpose | title | zip_code | addr_state | dti | delinq_2yrs | earliest_cr_line | fico_range_low | fico_range_high | inq_last_6mths | mths_since_last_delinq | mths_since_last_record | open_acc | pub_rec | revol_bal | revol_util | total_acc | initial_list_status | out_prncp | out_prncp_inv | total_pymnt | total_pymnt_inv | total_rec_prncp | total_rec_int | total_rec_late_fee | recoveries | collection_recovery_fee | last_pymnt_d | last_pymnt_amnt | next_pymnt_d | last_credit_pull_d | last_fico_range_high | last_fico_range_low | collections_12_mths_ex_med | mths_since_last_major_derog | policy_code | application_type | annual_inc_joint | dti_joint | verification_status_joint | acc_now_delinq | tot_coll_amt | tot_cur_bal | open_acc_6m | open_act_il | open_il_12m | open_il_24m | mths_since_rcnt_il | total_bal_il | il_util | open_rv_12m | open_rv_24m | max_bal_bc | all_util | total_rev_hi_lim | inq_fi | total_cu_tl | inq_last_12m | acc_open_past_24mths | avg_cur_bal | bc_open_to_buy | bc_util | chargeoff_within_12_mths | delinq_amnt | mo_sin_old_il_acct | mo_sin_old_rev_tl_op | mo_sin_rcnt_rev_tl_op | mo_sin_rcnt_tl | mort_acc | mths_since_recent_bc | mths_since_recent_bc_dlq | mths_since_recent_inq | mths_since_recent_revol_delinq | num_accts_ever_120_pd | num_actv_bc_tl | num_actv_rev_tl | num_bc_sats | num_bc_tl | num_il_tl | num_op_rev_tl | num_rev_accts | num_rev_tl_bal_gt_0 | num_sats | num_tl_120dpd_2m | num_tl_30dpd | num_tl_90g_dpd_24m | num_tl_op_past_12m | pct_tl_nvr_dlq | percent_bc_gt_75 | pub_rec_bankruptcies | tax_liens | tot_hi_cred_lim | total_bal_ex_mort | total_bc_limit | total_il_high_credit_limit | revol_bal_joint | sec_app_fico_range_low | sec_app_fico_range_high | sec_app_earliest_cr_line | sec_app_inq_last_6mths | sec_app_mort_acc | sec_app_open_acc | sec_app_revol_util | sec_app_open_act_il | sec_app_num_rev_accts | sec_app_chargeoff_within_12_mths | sec_app_collections_12_mths_ex_med | sec_app_mths_since_last_major_derog | hardship_flag | hardship_type | hardship_reason | hardship_status | deferral_term | hardship_amount | hardship_start_date | hardship_end_date | payment_plan_start_date | hardship_length | hardship_dpd | hardship_loan_status | orig_projected_additional_accrued_interest | hardship_payoff_balance_amount | hardship_last_payment_amount | disbursement_method | debt_settlement_flag | debt_settlement_flag_date | settlement_status | settlement_date | settlement_amount | settlement_percentage | settlement_term | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 42526 | 81085 | NaN | 10500.0 | 10500.0 | 275.0 | 36 months | 11.22% | 344.87 | C | C4 | Town of Plainville | 3 years | RENT | 60000.0 | Not Verified | Jun-2007 | Does not meet the credit policy. Status:Fully Paid | n | https://lendingclub.com/browse/loanDetail.action?loan_id=81085 | Replace my existing roof. | other | roof | 061xx | CT | 19.50 | NaN | NaN | 740.0 | 744.0 | NaN | 0.0 | NaN | NaN | NaN | 0.0 | NaN | NaN | f | 0.0 | 0.0 | 11219.852169 | 293.86 | 10500.00 | 719.85 | 0.0 | 0.00 | 0.00 | Aug-2008 | 0.00 | Aug-2008 | Jun-2007 | 744.0 | 740.0 | NaN | NaN | 1.0 | Individual | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | N | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | Cash | N | NaN | NaN | NaN | NaN | NaN | NaN |
| 42527 | 77792 | NaN | 3000.0 | 3000.0 | 125.0 | 36 months | 9.01% | 95.42 | B | B2 | Tanks Tavern | < 1 year | RENT | 35000.0 | Not Verified | Jun-2007 | Does not meet the credit policy. Status:Fully Paid | n | https://lendingclub.com/browse/loanDetail.action?loan_id=77792 | To pay off credit card and rent for the summer since I graduate at the end of the July. | other | Dep4774 | 665xx | KS | 10.00 | NaN | NaN | 715.0 | 719.0 | NaN | 0.0 | NaN | NaN | NaN | 0.0 | NaN | NaN | f | 0.0 | 0.0 | 3434.999452 | 143.12 | 3000.00 | 435.00 | 0.0 | 0.00 | 0.00 | Jul-2010 | 95.66 | Jul-2010 | Jun-2010 | 594.0 | 590.0 | NaN | NaN | 1.0 | Individual | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | N | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | Cash | N | NaN | NaN | NaN | NaN | NaN | NaN |
| 42528 | 77757 | NaN | 3000.0 | 3000.0 | 0.0 | 36 months | 9.33% | 95.86 | B | B3 | NaN | < 1 year | OWN | 20000.0 | Not Verified | Jun-2007 | Does not meet the credit policy. Status:Fully Paid | n | https://lendingclub.com/browse/loanDetail.action?loan_id=77757 | For home improvement | other | Home improvement | 024xx | MA | 10.00 | NaN | NaN | 710.0 | 714.0 | NaN | 0.0 | NaN | NaN | NaN | 0.0 | NaN | NaN | f | 0.0 | 0.0 | 3450.910526 | 0.00 | 3000.00 | 450.91 | 0.0 | 0.00 | 0.00 | Jun-2010 | 96.77 | Jul-2010 | May-2007 | 714.0 | 710.0 | NaN | NaN | 1.0 | Individual | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | N | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | Cash | N | NaN | NaN | NaN | NaN | NaN | NaN |
| 42529 | 74505 | NaN | 2000.0 | 2000.0 | 225.0 | 36 months | 9.96% | 64.50 | B | B5 | NaN | < 1 year | RENT | 6000.0 | Not Verified | Jun-2007 | Does not meet the credit policy. Status:Fully Paid | n | https://lendingclub.com/browse/loanDetail.action?loan_id=74505 | I just need enough money to make it until the fall. | other | Summer stuff | 325xx | FL | 10.00 | NaN | NaN | 685.0 | 689.0 | NaN | 0.0 | NaN | NaN | NaN | 0.0 | NaN | NaN | f | 0.0 | 0.0 | 2322.408993 | 261.27 | 2000.00 | 322.41 | 0.0 | 0.00 | 0.00 | Jul-2010 | 0.84 | Aug-2010 | Jul-2010 | 594.0 | 590.0 | NaN | NaN | 1.0 | Individual | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | N | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | Cash | N | NaN | NaN | NaN | NaN | NaN | NaN |
| 42530 | 74323 | NaN | 6500.0 | 6500.0 | 0.0 | 36 months | 9.64% | 208.66 | B | B4 | Air Force | < 1 year | RENT | 20000.0 | Not Verified | Jun-2007 | Does not meet the credit policy. Status:Charged Off | n | https://lendingclub.com/browse/loanDetail.action?loan_id=74323 | I'm in the military and before I came in I racked up a large credit card debt. With all the different payments to keep track of and extra charges it is really hard to get out from under them. With just one payment a month it would make my life easier, so I can concentrate on my job. | other | One-Debt Loan | 064xx | CT | 10.00 | NaN | NaN | 710.0 | 714.0 | NaN | 0.0 | NaN | NaN | NaN | 0.0 | NaN | NaN | f | 0.0 | 0.0 | 7193.060000 | 0.00 | 1791.32 | 503.81 | 0.0 | 4897.93 | 1714.27 | May-2008 | 208.65 | Dec-2008 | Aug-2018 | 534.0 | 530.0 | NaN | NaN | 1.0 | Individual | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | N | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | Cash | N | NaN | NaN | NaN | NaN | NaN | NaN |
| 42531 | 73582 | NaN | 3500.0 | 3500.0 | 225.0 | 36 months | 10.28% | 113.39 | C | C1 | NaN | < 1 year | RENT | 180000.0 | Not Verified | Jun-2007 | Does not meet the credit policy. Status:Fully Paid | n | https://lendingclub.com/browse/loanDetail.action?loan_id=73582 | I am getting married on July 28 and will need another $3,500 to pay the suppliers (catering, hotel, etc.). I would have never thought getting married was such an expensive proposition! Thanks for helping. | other | Wedding coming up | 100xx | NY | 10.00 | NaN | NaN | 685.0 | 689.0 | NaN | 0.0 | NaN | NaN | NaN | 0.0 | NaN | NaN | f | 0.0 | 0.0 | 3719.431070 | 239.11 | 3500.00 | 219.43 | 0.0 | 0.00 | 0.00 | Mar-2008 | 0.00 | Mar-2008 | Feb-2013 | 819.0 | 815.0 | NaN | NaN | 1.0 | Individual | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | N | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | Cash | N | NaN | NaN | NaN | NaN | NaN | NaN |
| 42532 | 72998 | NaN | 1000.0 | 1000.0 | 0.0 | 36 months | 9.64% | 32.11 | B | B4 | Halping hands company inc. | < 1 year | RENT | 12000.0 | Not Verified | Jun-2007 | Does not meet the credit policy. Status:Fully Paid | n | https://lendingclub.com/browse/loanDetail.action?loan_id=72998 | I would like to buy some new furniture in my apartment and TV | other | delight | 021xx | MA | 10.00 | NaN | NaN | 695.0 | 699.0 | NaN | 0.0 | NaN | NaN | NaN | 0.0 | NaN | NaN | f | 0.0 | 0.0 | 1155.600899 | 0.00 | 1000.00 | 155.60 | 0.0 | 0.00 | 0.00 | Jun-2010 | 32.41 | Jul-2010 | Sep-2014 | 784.0 | 780.0 | NaN | NaN | 1.0 | Individual | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | N | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | Cash | N | NaN | NaN | NaN | NaN | NaN | NaN |
| 42533 | 72176 | NaN | 2525.0 | 2525.0 | 225.0 | 36 months | 9.33% | 80.69 | B | B3 | NaN | < 1 year | RENT | 110000.0 | Not Verified | Jun-2007 | Does not meet the credit policy. Status:Fully Paid | n | https://lendingclub.com/browse/loanDetail.action?loan_id=72176 | I need to pay $2,100 for fixing my Volvo :) Any help appreciated! | other | Car repair bill | 100xx | NY | 10.00 | NaN | NaN | 710.0 | 714.0 | NaN | 0.0 | NaN | NaN | NaN | 0.0 | NaN | NaN | f | 0.0 | 0.0 | 2904.498829 | 258.82 | 2525.00 | 379.50 | 0.0 | 0.00 | 0.00 | Jun-2010 | 82.03 | Jul-2010 | May-2007 | 714.0 | 710.0 | NaN | NaN | 1.0 | Individual | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | N | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | Cash | N | NaN | NaN | NaN | NaN | NaN | NaN |
| 42534 | 71623 | NaN | 6500.0 | 6500.0 | 0.0 | 36 months | 8.38% | 204.84 | A | A5 | NaN | < 1 year | NONE | NaN | Not Verified | Jun-2007 | Does not meet the credit policy. Status:Fully Paid | n | https://lendingclub.com/browse/loanDetail.action?loan_id=71623 | Hi, I'm buying a used car. Anybody on facebook wants to finance me? Thanks | other | Buying a car | 100xx | NY | 4.00 | NaN | NaN | 740.0 | 744.0 | NaN | 0.0 | NaN | NaN | NaN | 0.0 | NaN | NaN | f | 0.0 | 0.0 | 7373.904962 | 0.00 | 6500.00 | 873.90 | 0.0 | 0.00 | 0.00 | Jun-2010 | 205.32 | Jul-2010 | Aug-2007 | 724.0 | 720.0 | NaN | NaN | 1.0 | Individual | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | N | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | Cash | N | NaN | NaN | NaN | NaN | NaN | NaN |
| 42535 | 70686 | NaN | 5000.0 | 5000.0 | 0.0 | 36 months | 7.75% | 156.11 | A | A3 | Homemaker | 10+ years | MORTGAGE | 70000.0 | Not Verified | Jun-2007 | Does not meet the credit policy. Status:Fully Paid | n | https://lendingclub.com/browse/loanDetail.action?loan_id=70686 | I need to make several improvements around the house - fix garage, fix back fencing, and misc other. | other | Aroundthehouse | 068xx | CT | 8.81 | NaN | NaN | 770.0 | 774.0 | NaN | 0.0 | NaN | NaN | NaN | 0.0 | NaN | NaN | f | 0.0 | 0.0 | 5619.762090 | 0.00 | 5000.00 | 619.76 | 0.0 | 0.00 | 0.00 | Jun-2010 | 156.39 | Jul-2010 | Feb-2015 | 794.0 | 790.0 | NaN | NaN | 1.0 | Individual | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | N | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | Cash | N | NaN | NaN | NaN | NaN | NaN | NaN |